Vlad,

> > No, I have slightly different opinion regarding EXECUTE PROCEDURE
> > handling in PSQL code.
> >
> > 3) EXECUTE PROCEDURE remains singleton construct and works
> either with
> > executable SP or singleton selectable SP.
> > If selectable SP does not return rows or returns more than
> one row we
> > need to handle it according to standard logic, basically raise
> > exception in both cases.
>
> This will break existing applications.
>
> > 4) SELECT should only work with selectable SP and should
> not compile
> > if you attempt to use it with executable SP.
>
> This will break existing applications.

I understand. But in both cases if things got broken user was certainly
not correct in what he was doing.
We may again add backwards-compatiblity parameter or dialect to help
users migrate their applications.

> Vlad

Nickolay