There are procedures in Postgres 8.3?

On Tue, Aug 18, 2009 at 12:48:49PM +0100, Andre Lopes wrote:

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...

Really, I've never noticed them! If you're asking about EnterpriseDB
specific features, I'd recommend asking on EnterpriseDB forums.

--
Sam http://samason.me.uk/

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