Thread: difference between function and stored procedure

Hello list,

Is there any difference between a PGSQL Function and Stored Procedure in PostgreSQL (8.2) ?

If so, what difference? Is the SQL used to create a SP different from the SQL used to create a function ?

Thanks in advance,

Marcelo.

On Aug 28, 2007, at 8:24 , Marcelo de Moraes Serpa wrote:

> Is there any difference between a PGSQL Function and Stored
> Procedure in
> PostgreSQL (8.2) ?

No.


Michael Glaesemann
grzm seespotcode net

On 8/28/07, Marcelo de Moraes Serpa <celoserpa@gmail.com> wrote:
> Hello list,
>
> Is there any difference between a PGSQL Function and Stored Procedure in
> PostgreSQL (8.2) ?
>
> If so, what difference? Is the SQL used to create a SP different from the
> SQL used to create a function ?

Strictly speaking, PostgreSQL doesn't have stored procedures.  It just
has functions that return type of void (or return only error codes
etc.)

So, no there's no difference really.