/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 vote228 views1 answer
Get the next column of a table in mysql
SQL
0 vote209 views1 answer
Sql server create constraint
SQL
6 votes193 views3 answers
Mysql first day of year
SQL
7 votes232 views2 answers
How to create index mysql
SQL
1 vote213 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote215 views1 answer
Mysql multiple primary keys
SQL
0 vote219 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote265 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
17 votes207 views3 answers
Cast in sql server
SQL
4 votes210 views1 answer
Alter session set nls_date_format
SQL