/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 vote260 views1 answer
Install ms sql server management studio
SQL
4 votes299 views1 answer
Oracle nls_date_format
SQL
1 vote272 views1 answer
Sql server datetime vs datetime2
SQL
0 vote264 views1 answer
T-sql check if data exists
SQL
17 votes269 views6 answers
Sql select distinct
SQL
9 votes259 views2 answers
Oracle all tables in schema
SQL
3 votes259 views2 answers
Sqlite show table definition
SQL
0 vote277 views1 answer
Kill a pid redshift
SQL
0 vote265 views1 answer
Partitioning in oracle-base
SQL
3 votes270 views2 answers
How to load files in mysql
SQL