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
