Re: BUG #5479: PosgreSQL Documentation does not mention OPEN - Mailing list 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