Re: "stored procedures" - use cases? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: "stored procedures" - use cases?
Date
Msg-id 648.1303856935@sss.pgh.pa.us
Whole thread Raw
In response to Re: "stored procedures" - use cases?  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: "stored procedures" - use cases?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: "stored procedures" - use cases?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: XML with invalid chars
Next
From: "Kevin Grittner"
Date:
Subject: Re: "stored procedures" - use cases?