Re: How to get the row that start a trigger

On 8/31/06, Ezequias Rodrigues da Rocha <ezequias(dot)rocha(at)gmail(dot)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
==================================================================