Postgres Pro
Downloads
Home   >   mailing lists

looping on NEW and OLD in a trigger - Mailing list pgsql-general

From Michael P. Soulier
Subject looping on NEW and OLD in a trigger
Date
Msg-id 20100826154548.GD6913@e-smith.com
Whole thread Raw
Responses Re: looping on NEW and OLD in a trigger
Re: looping on NEW and OLD in a trigger
List pgsql-general
Tree view 
Hi,

I'm very new to writing postgres procedures, and I'm trying to loop over
the fields in the NEW and OLD variables available in an after trigger,
and I can't quite get the syntax correct.

Could someone point me at an example?

Thanks,
Mike
--
Michael P. Soulier <michael_soulier@mitel.com>, 613-592-2122 x2522
"Any intelligent fool can make things bigger and more complex... It takes a
touch of genius - and a lot of courage to move in the opposite direction."
--Albert Einstein

pgsql-general by date:

Previous
From: bricklen
Date:
Subject: Re: unexpected message type 0x58 during COPY from stdin
Next
From: Tom Lane
Date:
Subject: Re: looping on NEW and OLD in a trigger