Re: difference between function and stored procedure

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Marcelo de Moraes Serpa" <celoserpa(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: difference between function and stored procedure
Date: 2007-08-28 14:07:10
Message-ID: dcc563d10708280707p3dc78eddgc3b0c38ca0d904fb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/28/07, Marcelo de Moraes Serpa <celoserpa(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Keaton Adams 2007-08-28 14:07:12 Turning off atime on PostgreSQL DB volumes
Previous Message Michael Glaesemann 2007-08-28 13:31:59 Re: difference between function and stored procedure