Postgres Pro
Downloads
Home   >   mailing lists

Re: Passing arguments to a function called by a trigger - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: Passing arguments to a function called by a trigger
Date
Msg-id 20130727130539.GA3062@tux
Whole thread Raw
In response to Passing arguments to a function called by a trigger  (Some Developer <someukdeveloper@gmail.com>)
Responses Re: Passing arguments to a function called by a trigger  (Some Developer <someukdeveloper@gmail.com>)
List pgsql-novice
Tree view 
Some Developer <someukdeveloper@gmail.com> wrote:

> I have an INSERT AFTER trigger that runs on inserts into a specific
> table. I'm not sure if the function automatically gets all the
> information that was inserted into the table or whether you have to
> manually pass it in?

NEW.<colum_name> is your friend ;-)


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-novice by date:

Previous
From: Some Developer
Date:
Subject: Passing arguments to a function called by a trigger
Next
From: Some Developer
Date:
Subject: Re: Passing arguments to a function called by a trigger