Statement triggers 7.4 NEW/OLD

From: Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Statement triggers 7.4 NEW/OLD
Date: 2003-04-24 11:41:30
Message-ID: 3EA7CD6A.9080404@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

How can I address the rows affected by an insert/update/delete statement
in pl/pgsql?
The doc says that NEW and OLD will be NULL for statement triggers, which
makes sense because NEW and OLD are of type RECORD, capable of holding
only a single row.
So where's the beef?

Regards,
Andreas

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Robert Treat 2003-04-24 16:25:44 rewriting values with before trigger
Previous Message Vernon 2003-04-24 04:18:23 Unicode, RedHat Linux, & PostgreSQL