/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 vote165 views3 answers
Create and attach user to a postgresql database
SQL
3 votes197 views3 answers
1396(hy00) mysql error
SQL
1 vote176 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote155 views1 answer
Mysql regex exact match
SQL
19 votes175 views2 answers
Mysql tinyint max value
SQL
0 vote167 views1 answer
Sql server select value large text
SQL
0 vote188 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote178 views1 answer
Compression of dabatase mysqldumo
SQL
1 vote196 views1 answer
Oracle plan hash value
SQL
0 vote196 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL