/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

2 votes247 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote260 views1 answer
Datagrip exec
SQL
3 votes244 views1 answer
What is having clause
SQL
8 votes280 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote261 views1 answer
Database timezone
SQL
-1 vote254 views1 answer
How to check table exists or not in postgresql
SQL
0 vote293 views1 answer
Alter domain sql
SQL
-1 vote224 views1 answer
Oracle db list usernames
SQL
9 votes246 views3 answers
Mysql get last id
SQL
0 vote267 views1 answer
Sqlite to csv statement
SQL