Re: [SQL] knowing which columns have beend UPDATEd inside a TRIGGER?

On Tue, Oct 24, 2000 at 06:51:03PM -0400, Tom Lane wrote: > Louis-David Mitterrand <[EMAIL PROTECTED]> writes: > > Is there a way to know which columns are being UPDATEd or INSERTEd from > > inside a trigger, either in C or pl/pgsql? > > Huh? An INSERT always inserts all columns, by definition.

Re: [SQL] knowing which columns have beend UPDATEd inside a TRIGGER?

Tom Lane <[EMAIL PROTECTED]> writes: > Louis-David Mitterrand <[EMAIL PROTECTED]> writes: > > Is there a way to know which columns are being UPDATEd or INSERTEd from > > inside a trigger, either in C or pl/pgsql? > > Huh? An INSERT always inserts all columns, by definition. Some of them > migh

[SQL] knowing which columns have beend UPDATEd inside a TRIGGER?

Hello, Is there a way to know which columns are being UPDATEd or INSERTEd from inside a trigger, either in C or pl/pgsql? Thanks in advance, -- Louis-David Mitterrand - [EMAIL PROTECTED] - http://www.apartia.org If at first you don't succeed, redefine success.

Re: [SQL] knowing which columns have beend UPDATEd inside a TRIGGER?

Louis-David Mitterrand <[EMAIL PROTECTED]> writes: > Is there a way to know which columns are being UPDATEd or INSERTEd from > inside a trigger, either in C or pl/pgsql? Huh? An INSERT always inserts all columns, by definition. Some of them might be null and/or equal to their default values, bu