+ Reply to Thread
Results 1 to 2 of 2

Re: [GENERAL] Cursor

  1. Re: [GENERAL] Cursor

    Christophe wrote:
    > On Jul 29, 2008, at 2:35 PM, Tom Lane wrote:
    > > No, he does need an OPEN.

    >
    > Really? I thought that PG didn't use OPEN:
    >
    > "The PostgreSQL server does not implement an OPEN statement for
    > cursors; a cursor is considered to be open when it is declared."
    >
    > http://www.postgresql.org/docs/8.3/i...l-declare.html
    >

    It's different in PL/pgSQL.

    "Before a cursor can be used to retrieve rows, it must be opened. (This
    is the equivalent action to the SQL command DECLARE CURSOR.)"

    http://www.postgresql.org/docs/8.3/i...l-cursors.html


    klint.

    --
    Klint Gore
    Database Manager
    Sheep CRC
    A.G.B.U.
    University of New England
    Armidale NSW 2350

    Ph: 02 6773 3789
    Fax: 02 6773 3266
    EMail: kgore4@une.edu.au


    --
    Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
    To make changes to your subscription:
    http://www.postgresql.org/mailpref/pgsql-general


  2. Re: [GENERAL] Cursor


    On Jul 29, 2008, at 4:51 PM, Klint Gore wrote:
    > It's different in PL/pgSQL.


    Ah, yes, sorry, didn't catch that it was a PL/pgSQL function.

    --
    Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
    To make changes to your subscription:
    http://www.postgresql.org/mailpref/pgsql-general


+ Reply to Thread