/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 vote265 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
54 votes341 views6 answers
Sql rename column
SQL
1 vote214 views1 answer
Oracle create_program
SQL
0 vote214 views1 answer
Replace sqlalchemy
SQL
0 vote251 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
1 vote163 views1 answer
How to run sql script
SQL
6 votes217 views2 answers
Mysql version check cmd
SQL
0 vote226 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote203 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote212 views1 answer
Mysql max number not returning correct value
SQL