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

From Bruce Momjian
Subject Re: "stored procedures" - use cases?
Date
Msg-id 201105100020.p4A0K6v11828@momjian.us
Whole thread Raw
In response to Re: "stored procedures" - use cases?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: "stored procedures" - use cases?  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
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. +


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: "stored procedures" - use cases?
Next
From: Alvaro Herrera
Date:
Subject: Re: Formatting Curmudgeons WAS: MMAP Buffers