Re: Stored procedures and out parameters

>
>
> In other words, being more like the SQL standard is probably good, but
> breaking compatibility is bad. You've technically avoided a
> *backward* compatibility break by deciding that functions and
> procedures can work differently from each other, but that just moves
> the problem around. Now instead of being unhappy that existing code
> is broken, people are unhappy that the new thing doesn't work like the
> existing thing. That may be the lesser of evils, but it's still
> pretty evil. People are not being unreasonable to want to call some
> code stored on the server without having to worry about whether that
> code is in a box labelled PROCEDURE or a box labelled FUNCTION.
>
>
Reading this from the (JDBC) drivers perspective, which is probably a
fairly popular one,
We now have a standard that we can't really support. Either the driver will
have to support
the new PROCEDURE with the {call } mechanism or stay with the existing
FUNCTIONS.
This puts the drivers in a no win situation.

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. Nevertheless, I predict that this is going to be an ongoing
> source of pain for a long time to come.
>
> Undoubtedly.. surely the opportunity to do something about this has not
passed as this has not been
officially released ?

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com