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.
James
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
