Re: [SQL] How to get the row that start a trigger

[Aaron Bono]

On 8/31/06, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote:

Hi,

I need make a trigger that update a table each time another table has a insert. but this insert has on this row all the items to pass to my function on the trigger.

How to retrieve this information.

 

See the example at the end of the page http://www.postgresql.org/docs/8.1/interactive/triggers.html - how it uses the OLD and NEW implicit variable.  You can use NEW.column_name to access the data being inserted into the table.

Does this help?

==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================