James Mansion wrote:
> Josh Berkus wrote:
>> Not only would they be generally useful for SP programming, but
>> multisets would eliminate one of the big hurdles in re-writing T-SQL
>> stored procedures in PG, and thus make it easier to port from SQL
>> Server. You don't hear a lot of demand for multisets on the mailing
>> lists because we're not getting those SQL Server / Sybase crossovers
>> now.
>>
> Its true that multiple result sets are a big deal with T-SQL
> programming: but I think you'll also need to provide a way for the
> locking model to behave in a similar way and also very importantly to
> be able to emulate the after-statement triggers view of new and old
> images.
I don't think we need to (or, for that matter, are able to) change the
locking model, but the NEW and OLD views of for-statement triggers
should be just a SMOP.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support