/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
Postgres list all stored procedures query
SQL
0 vote188 views1 answer
Mysql select where field is a value
SQL
8 votes214 views4 answers
Convert date to dd/mm/yyyy sql
SQL
0 vote176 views1 answer
How to write if case in select query in select statement
SQL
13 votes179 views2 answers
Sql join
SQL
0 vote175 views1 answer
Sql find all different values in column
SQL
0 vote171 views1 answer
Mysql drop multiple tables at once
SQL
-1 vote212 views3 answers
SQL MM/dd/yyyy format
SQL
0 vote164 views1 answer
SQL Server format datetime
SQL
0 vote967 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL