Hello.
OK. I created a new table that holds information about rows inserted/updated in a transaction.
I realized that after row-level trigger fires always before after statement-level trigger.
Therefore I can use row-level triger to populate the auxiliary table which holds information about affected rows, so that after statement-level trigger can read that information.
It works and is fast enough.
So, I emulated NEW and OLD for statement level trigger:)
Regards,
Zlatko
----- Original Message -----
Sent: Tuesday, July 10, 2007 10:17 AM
Subject: Re: [GENERAL] plpgsql equivalent to plperl $_SHARED and plpythonu global dictionary GD?
On 7/9/07, Zlatko Matic <zlatko.matic1@sb.t-com.hr> wrote: Does plpgsql has something equivalent to plperl $_SHARED or plpythonu global
dictionary GD?
no, but you can use some table to emulate this. or a temp table.
depesz
--
http://www.depesz.com/ - nowy, lepszy depesz