Re: "stored procedures" - use cases?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: "stored procedures" - use cases?
Date: 2011-04-26 22:28:55
Message-ID: 648.1303856935@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> On mn, 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2011-04-26 22:49:50 Re: "stored procedures" - use cases?
Previous Message Peter Eisentraut 2011-04-26 22:02:59 Re: XML with invalid chars