Re: returning multiple result sets from a stored procedure - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: returning multiple result sets from a stored procedure
Date
Msg-id 4C890AA302000025000354AD@gw.wicourts.gov
Whole thread Raw
In response to Re: returning multiple result sets from a stored procedure  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: returning multiple result sets from a stored procedure  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I'm with Robert: this would be a huge extra complication for a
> remarkably small amount of benefit.
This is probably heresy, but unless it's required by the standard or
drop-dead simple to allow, I'd be fine with *not* supporting
overloading of stored procedure names based on argument types at
all.  I can see the need for to support it for functions; I can't
think where it would be all that useful for stored procedures.  If
unique stored procedure names were required, it seems we might be
able to allow assignment casts on parameters, which might be more
useful.
I'm probably missing some good use case....
-Kevin


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: returning multiple result sets from a stored procedure
Next
From: Pavel Stehule
Date:
Subject: Re: returning multiple result sets from a stored procedure