On 30/08/2018 21:35, Robert Haas wrote:
> The semantics you've chosen for procedures are more like Oracle that
> the existing function semantics, which, as I can attest from my work
> experience, can be very useful for users looking to migrate. Worth
> noting, however, is Oracle also has those semantics for function
> calls. So what you've ended up creating here is a situation where
> procedures behave more or less like they do in Oracle and the SQL
> standard, but functions behave the way they historically have in
> PostgreSQL. That's kind of a weird incompatibility, and I think that
> incompatibility is a significant part of what people are complaining
> about.
> This probably should have been discussed in more detail before this
> got committed, but I guess that's water under the bridge at this
> point.
Note that OUT parameters in procedures are not implemented yet, so you
didn't miss any discussion, but it's a discussion I would like to have
in the future, and not in haste.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services