Re: Procedures - Mailing list pgsql-docs

From Jürgen Purtz
Subject Re: Procedures
Date
Msg-id 405998a6-bb25-40e9-edd9-79a681341012@purtz.de
Whole thread Raw
In response to Re: Procedures  (Robin Abbi <robin.abbi@downley.net>)
Responses Re: Procedures  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-docs
On 22.08.20 13:05, Robin Abbi wrote:
On Fri, 21 Aug 2020 at 23:52, Bruce Momjian <bruce@momjian.us> wrote:
I developed the attached patach for this.  Is this sufficient?

Would it be appropriate to consider including some language with a similar information content to this
" ... prior to PostgreSQL 11, these functions were unable to manage their own transactions. PostgreSQL 11 adds SQL procedures that can perform full transaction management within the body of a function, enabling developers to create more advanced server-side applications, such as ones involving incremental bulk data loading."

Robin Abbi

Can we more clearly distinguish between "function" and "procedure"? eg:
"Developers have been able to create user-defined functions in PostgreSQL since decades, but functions are unable to manage their own transactions. PostgreSQL 11 adds SQL procedures that can perform full transaction management within their body, enabling developers to create more advanced server-side applications, such as ones involving incremental bulk data loading."

as a modification of the original release notes:

"Developers have been able to create user-defined functions in PostgreSQL for over 20 years, but prior to PostgreSQL 11, these functions were unable to manage their own transactions. PostgreSQL 11 adds SQL procedures that can perform full transaction management within the body of a function, enabling developers to create more advanced server-side applications, such as ones involving incremental bulk data loading." --

J. Purtz

pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Minor fixes for PostgreSQL 13 documentation
Next
From: "David G. Johnston"
Date:
Subject: Re: Procedures