Re: returning multiple result sets from a stored procedure

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> To be honest, I am already pretty unhappy with
> the changes that make it impossible to redefined foo(a int) as
> foo(anteater int), which is a perfectly reasonable thing to want to do
> but which is now forbidden because someone MIGHT have called the
> function as foo(a := 3), and I certainly don't want to make it any
> worse. Whether there are actually any stored queries that call the
> function this way (or at all) is doesn't matter: it's not allowed.

BTW, before anyone suggests it: it wouldn't really improve matters if
we were to allow renaming so long as we couldn't find any such calls in
stored queries. We don't have any ability to track calls occuring in
stored procedures, let alone on the client side; so a rename would still
put you at very substantial risk of breaking things.

regards, tom lane