Re: Porting MSSQL to PGSQL -- triggers

Mischa Sandberg <mischa@ca.sophos.com>

From: Mischa Sandberg <mischa@ca.sophos.com>
To: pgsql-hackers@postgresql.org
Date: 2006-05-23T23:39:56Z
Lists: pgsql-hackers
Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>> How expensive is this going to be, especially for huge numbers of rows? 
> 
> Certainly cheaper than firing a per-row trigger.

I'm curious: I've never written a MSSQL trigger that did NOT use the 
INSERTED/DELETED pseudotables (aka NEW/OLD). I know STATEMENT-level triggers 
have existed in PG for a while ... but what do people use them for???

-- 
Engineers think that equations approximate reality.
Physicists think that reality approximates the equations.
Mathematicians never make the connection.