| From: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
|---|---|
| To: | Kurt wagner <kurt(dot)wagner(at)leoni(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #5479: PosgreSQL Documentation does not mention OPEN |
| Date: | 2010-05-28 09:20:37 |
| Message-ID: | 4BFF8AE5.1090607@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 28/05/10 12:06, Kurt wagner wrote:
> When checking the Web Site
> http://www.postgresql.org/docs/8.4/static/sql-commands.html
>
> I recognized that the commands "declare" and "close" are documented, but I
> failed to find "open".
OPEN is not an SQL command like DECLARE and CLOSE. It is part of
PL/pgSQL and will only work within a PL/pgSQL function, it is documented
at
http://www.postgresql.org/docs/8.4/static/plpgsql-cursors.html#PLPGSQL-CURSOR-OPENING.
Also note that PL/pgSQL's DECLARE and CLOSE are different from the SQL
commands DECLARE and CLOSE.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jasen Betts | 2010-05-28 10:26:03 | Re: BUG #5476: sequence corruption |
| Previous Message | Kurt wagner | 2010-05-28 09:06:05 | BUG #5479: PosgreSQL Documentation does not mention OPEN |