Re: "stored procedures" - use cases?

Tom Lane wrote:
> Peter Eisentraut <peter_e@gmx.net> writes:
> > On mån, 2011-04-25 at 14:35 -0500, Kevin Grittner wrote:
> >> (1)  All the \d commands in psql should be implemented in SPs so
> >> that they are available from any client, through calling one SP
> >> equivalent to one \d command.
> 
> > You don't need stored procedures with special transaction behavior for
> > this.
> 
> No, but what you *would* need is the ability to return multiple result
> sets from one call.  Even then, you could not exactly duplicate the
> current output of \d; but you could duplicate the functionality.

Oh, good point.  Thanks.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +