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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
