Gavin Sherry wrote:
> Do you have any idea about databases returning result sets from SQL
> procedures (ie, not functions).
As other's have pointed out, this is very common in the MS SQL Server
world (and I believe Sysbase also supports it). It works like:
<begin proc def>
select * from something
select * from somethingelse
<end proc def>
We get requests for this kind of functionality at least a couple of
times a month, and although it's been a few years since I mucked with
MSSQL, I found it to be very useful in a number of different circumstances.
It is only workable because stored procedures cannot participate in
normal SELECT statements. In MSSQL you would do something like:
-- or --
so the analogy to your stored procedure proposal holds:
-- or --
I had always envisioned implementing this by projecting tuples directly
the way that SHOW ALL or EXPLAIN ANALYZE do. See, e.g.
ShowAllGUCConfig() in guc.c.
In response to
pgsql-hackers by date
|Next:||From: Fabien COELHO||Date: 2004-09-23 16:03:16|
|Subject: Re: BUG: possible busy loop when connection is closed|
|Previous:||From: Andrew Dunstan||Date: 2004-09-23 15:41:16|
|Subject: Re: Use of zlib|