/SQL/Cannot return non-composite value from function that returns composite type

Cannot return non-composite value from function that returns composite type

--EXAMPLE OF A UPDATE FUNCTION WITH TRIGGER PLPGSQL

CREATE OR REPLACE FUNCTION update_aumentarpreco ()
    RETURNS TRIGGER
    LANGUAGE PLPGSQL
    AS 
    $BODY$
BEGIN
    IF NEW.ps_availqty = 2 THEN
        NEW.ps_supplycost = OLD.ps_supplycost * 0.10;
        RETURN NEW;
    END IF;
    RETURN NULL;
END;
$BODY$ 

CREATE TRIGGER update_aumentarpreco
    BEFORE UPDATE OF ps_availqty ON partsupp
    FOR EACH ROW
    EXECUTE PROCEDURE update_aumentarpreco ();

Similar codes

0 vote272 views1 answer
Django mysqlclient connection string
SQL
0 vote318 views1 answer
Insert value in identity
SQL
2 votes281 views1 answer
Apex execute batch job
SQL
1 vote309 views1 answer
Table valued functions in sql
SQL
0 vote271 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote277 views4 answers
Mysql replace regex
SQL
2 votes279 views1 answer
Oracle sql concatenate results into string
SQL
13 votes285 views5 answers
Sql default
SQL
22 votes320 views3 answers
How to join three tables in sql using joins
SQL
0 vote291 views1 answer
Test sql query
SQL