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