Re: Porting MSSQL to PGSQL -- triggers - Mailing list pgsql-hackers

From Mischa Sandberg
Subject Re: Porting MSSQL to PGSQL -- triggers
Date
Msg-id 44739D4C.2020800@ca.sophos.com
Whole thread Raw
In response to Re: Porting MSSQL to PGSQL (Was: [OT] MySQL is bad, but THIS bad?)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Why is CVS server so slow?
Next
From: Michael Glaesemann
Date:
Subject: Re: SQL compliant interval implementation