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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
