Merlin, Pavel,

> Mutable session variables would be nice, but I'll take a plpgsql
> langauge (or psm) with or without them, so long as transactions are
> manual.  It's possible to emulate variables using scalar functions
> with the desired volatility currently (but you still have to be
> careful with transactions).

The other big useful feature we're missing from Functions is multisets.  
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.

Of course, Pavel can implement one of these features at a time ...

-- 
Josh Berkus
PostgreSQL Lead
Sun Microsystems
San Francisco
01-415-752-2500

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to