Re: There are procedures in Postgres 8.3? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: There are procedures in Postgres 8.3?
Date
Msg-id 162867790908180548x36c6b311l7eee60e1ef44677c@mail.gmail.com
Whole thread Raw
In response to There are procedures in Postgres 8.3?  (Andre Lopes <lopes80andre@gmail.com>)
List pgsql-general
2009/8/18 Andre Lopes <lopes80andre@gmail.com>:
> Hi,
>
> I have some functions developed in postgres to work as a procedure. But now
> I see in the Postgres Studio that we have the option to create a
> procedure... So my question? there are procedures in Postgres 8.3? If yes,
> what the correct syntax to write procedures in Postgres 8.3?

No, PostgreSQL doesn't support stored procedures - only stored functions.

I don't know Postgres Studio - It maybe support EnterpriseDB, that
supports stored procedures in PL/SQL syntax.

regards
Pavel Stehule


>
> Best Regards,
> André.
>
>

pgsql-general by date:

Previous
From: "Andrus Moor"
Date:
Subject: index "pg_authid_rolname_index" is not a btree
Next
From: Sam Mason
Date:
Subject: Re: Best database model for canvassing (and analysing) opinion