Postgres Pro
Downloads
Home   >   mailing lists

Re: [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them - Mailing list pgsql-sql

From Tom Lane
Subject Re: [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them
Date
Msg-id 13845.1280263824@sss.pgh.pa.us
Whole thread Raw
In response to [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them  (Torsten Zühlsdorff <foo@meisterderspiele.de>)
Responses Re: [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them  (Torsten Zühlsdorff <foo@meisterderspiele.de>)
List pgsql-sql
Tree view 
Torsten Zühlsdorff <foo@meisterderspiele.de> writes:
> I have defined an BEFORE UPDATE trigger. The trigger catch every update, 
> change some columns of the new row, make an insert of the new row and 
> returns null to abort the update.

Why in the world would you do that?  Just return the modified row from
the trigger and let the update proceed normally.
        regards, tom lane

pgsql-sql by date:

Previous
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: grouping subsets
Next
From: Torsten Zühlsdorff
Date:
Subject: Re: [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them