Thread: BUG #5479: PosgreSQL Documentation does not mention OPEN

The following bug has been logged online:

Bug reference:      5479
Logged by:          Kurt wagner
Email address:      kurt.wagner@leoni.com
PostgreSQL version: 8.4
Operating system:   HP-UX
Description:        PosgreSQL Documentation does not mention OPEN
Details:

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".

Could you please add it sometime?

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