Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get the row that start a trigger - Mailing list pgsql-sql

From Aaron Bono
Subject Re: How to get the row that start a trigger
Date
Msg-id bf05e51c0609031617l491ddaddnb91ccb322ff2c3bf@mail.gmail.com
Whole thread Raw
In response to How to get the row that start a trigger  ("Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>)
List pgsql-sql
Tree view
On 8/31/06, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> 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
==================================================================

pgsql-sql by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Mac Address
Next
From: Markus Schaber
Date:
Subject: Re: help with pagila