| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Andre Lopes <lopes80andre(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: There are procedures in Postgres 8.3? |
| Date: | 2009-08-18 12:48:19 |
| Message-ID: | 162867790908180548x36c6b311l7eee60e1ef44677c@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2009/8/18 Andre Lopes <lopes80andre(at)gmail(dot)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é.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sam Mason | 2009-08-18 12:49:11 | Re: Best database model for canvassing (and analysing) opinion |
| Previous Message | Andrus Moor | 2009-08-18 12:35:49 | index "pg_authid_rolname_index" is not a btree |