/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 vote284 views1 answer
Oracle index partition
SQL
0 vote357 views1 answer
Python get backup of sql
SQL
0 vote299 views1 answer
Change database name psql 8
SQL
2 votes268 views1 answer
Mysql add boolean column
SQL
2 votes309 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote294 views1 answer
Set classpath for mysql-connector.jar
SQL
5 votes293 views3 answers
Oracle first day of last year
SQL
2 votes281 views2 answers
Checking data type in sql server
SQL
0 vote317 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote309 views1 answer
How to write if case in select query in select statement
SQL