/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

1 vote294 views1 answer
Sqlserver create table from select
SQL
0 vote283 views1 answer
Sql tablo hangi sp de
SQL
1 vote286 views1 answer
Rails run native ssql query
SQL
0 vote270 views2 answers
Mysql multiply
SQL
0 vote245 views1 answer
Big query add table rows to another table
SQL
6 votes313 views2 answers
Foreign key sqlite3 python
SQL
0 vote271 views1 answer
Fill up postgres db
SQL
1 vote290 views1 answer
How to show index type in postgresql
SQL
0 vote271 views1 answer
Implizite joins sql
SQL
0 vote296 views1 answer
Add mysql database to power bi web
SQL