/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 vote221 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote249 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
1 vote222 views1 answer
Postgres get month name from date
SQL
0 vote225 views1 answer
Sql server udf performance
SQL
0 vote229 views1 answer
Android sqlite add column if not exists
SQL
0 vote221 views1 answer
Sql last 7 days
SQL
0 vote214 views1 answer
Is not null postgresql
SQL
-1 vote223 views2 answers
On update cascade
SQL
0 vote243 views1 answer
Différence entre deux dates sql oracle
SQL
32 votes232 views6 answers
Insert into values select
SQL