Re: [HACKERS] SQL procedures - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] SQL procedures
Date
Msg-id 11024.1514911665@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] SQL procedures  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] SQL procedures
Re: [HACKERS] SQL procedures
Re: [HACKERS] SQL procedures
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> I agree that we need this, but using prorettype = InvalidOid to do it
> might not be the best way, because it only works for procedures that
> don't return anything.  If a procedure could return, say, an integer,

Good point, because that is possible in some other systems, and so
somebody is going to ask for it at some point.

> Anyway, I think it would be better to invent an explicit way to
> represent whether something is a procedure rather than relying on
> overloading prorettype to tell us.

+1 --- seems like a new bool column is the thing.  Or may we should merge
"proisprocedure" with proisagg and proiswindow into an enum prokind?
Although that would break some existing client-side code.

PS: I still strongly disagree with allowing prorettype to be zero.

            regards, tom lane


pgsql-hackers by date:

Previous
From: David Steele
Date:
Subject: Re: PATCH: Configurable file mode mask
Next
From: Peter Eisentraut
Date:
Subject: Re: Package version in PG_VERSION and version()