| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>, Guyren Howe <guyren(at)gmail(dot)com>, raf <raf(at)raf(dot)org>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "Bysani, Ram" <rbysani(at)informatica(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Need help with clarification on stored procedure support in PostGreSQL database |
| Date: | 2021-03-09 22:21:49 |
| Message-ID: | 2047266.1615328509@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> The omission of the "OUT" parameter mode seems intentional since at present
> our procedures do not support OUT mode parameters.
Um, I just created one. I think this *used* to be true, and this bit of
the docs didn't get fixed. If I back-patch this, I'll have to research
when it changed.
> Instead of "The difference" or "One difference" I would suggest: "However,
> a procedure does not return a value, so there is no return type
> declaration; though a procedure can declare INOUT (but not plain OUT)
> parameters."
Not sure if that's an improvement.
> Relocating the links to the description instead of usage is good. The
> additional procedure link after the examples seems redundant, particularly
> as the linked to location doesn't actually have more examples.
I was modeling that on the existing pattern in create_function.sgml,
which has similar verbiage in the EXAMPLES section. But I suppose
we could drop that if we have a link in the description section.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vincent Veyron | 2021-03-09 23:03:45 | Re: unexpected character used as group separator by to_char |
| Previous Message | David G. Johnston | 2021-03-09 22:16:11 | Re: Need help with clarification on stored procedure support in PostGreSQL database |