difference between function and stored procedure

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.