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

From Andrew Dunstan
Subject Re: "stored procedures" - use cases?
Date
Msg-id 4DC89303.9070006@dunslane.net
Whole thread Raw
In response to Re: "stored procedures" - use cases?  (Bruce Momjian <bruce@momjian.us>)
Responses Re: "stored procedures" - use cases?  (Christopher Browne <cbbrowne@gmail.com>)
List pgsql-hackers

On 05/09/2011 08:20 PM, Bruce Momjian wrote:
> 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.

Multiple resultsets in one call would be a good thing, though, no?

cheers

andrew


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Formatting Curmudgeons WAS: MMAP Buffers
Next
From: Greg Smith
Date:
Subject: Re: Formatting Curmudgeons WAS: MMAP Buffers