/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

5 votes148 views1 answer
Purge undo tablespace usage
SQL
0 vote122 views1 answer
Update if else mysql
SQL
7 votes150 views3 answers
Sql server reset auto increment
SQL
0 vote131 views1 answer
Create table sql generator
SQL
1 vote137 views1 answer
Select from describe sql
SQL
3 votes204 views1 answer
Sql add two values together
SQL
1 vote143 views1 answer
Select tables with name like mysql
SQL
0 vote138 views1 answer
Create database store
SQL
0 vote126 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
0 vote135 views1 answer
Mysql cli output to a file
SQL