Skip site navigation (1) Skip section navigation (2)

Triggers: FROM Inserted

From: "Peter Stow" <peters(at)BarwonHealth(dot)org(dot)au>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Triggers: FROM Inserted
Date: 2007-09-14 05:54:44
Message-ID: D56CD37836AC1C4682B3CA1135AFAA670836EF38@TGH-EXVS01.bh.local (view raw or flat)
Thread:
Lists: pgsql-novice
Hi

I am trying to migrate an application from MS SQL Server to Postgres.  In MS SQL triggers I have been used to declaring variables inserted into a table using the syntax 'SELECT . . . FROM Inserted'.  Can anyone tell me if it is possible to use the same syntax (ie FROM Inserted) in Postgres?  If not, is there an alternative?

Thanks.

Responses

pgsql-novice by date

Next:From: A. KretschmerDate: 2007-09-14 06:18:32
Subject: Re: Triggers: FROM Inserted
Previous:From: David GardnerDate: 2007-09-12 14:08:22
Subject: Re: Passing column name to a function at runtime

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group