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