Re: Stored Procedure examples

Dave Page wrote:
> pgAdmin defines a stored procedure as:
>
> - A function on EnterpriseDB 8.0 or above, written in edbspl.

Why does EnterpriseDB determine what is a stored procedure in
PostgreSQL?  Shouldn't that be limited to their own version of pgAdmin?

> - A function written in EnterpriseDB or PostgreSQL 8.1 or above with
> OUT or INOUT arguments.

What sense does that make?

> The separation (in pgAdmin) is historic, and comes from EnterpriseDB
> which treats the two object types more distinctly for Oracle
> compatibility (and had SPs before PostgreSQL).

The SQL standard does define procedures distinct from functions, and we
might want to add that someday, so that system isn't going to make
sense anymore.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/