Re: Need help with clarification on stored procedure support in PostGreSQL database

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 23:50:43
Message-ID: 2050799.1615333843@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:
> On Tue, Mar 9, 2021 at 3:21 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
>>> 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.

> The "however" part is probably a wash; I just dislike seeing a count
> started and not having an ending and thus being left in a state of "what
> didn't they include that's important".

The rest of the paragraph is what's important enough to include here.

I very strongly dislike the existing "The difference ..." wording,
because it implies that that's the only difference, which is immediately
belied by the rest. "However" isn't a lot better. Would it be better
to turn the para into a bulleted list, which we could introduce with
"The key differences are:" ?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2021-03-09 23:54:10 Re: Need help with clarification on stored procedure support in PostGreSQL database
Previous Message David G. Johnston 2021-03-09 23:16:45 Re: Need help with clarification on stored procedure support in PostGreSQL database