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