Re: PQexecParams and CURSOR - Mailing list pgsql-general

From Laurent Marzullo
Subject Re: PQexecParams and CURSOR
Date
Msg-id NDEKIMJLKBNGEIOBDFOJIEFBDEAA.laurent.marzullo@atosorigin.com
Whole thread Raw
In response to Re: PQexecParams and CURSOR  (Michael Fuhr <mike@fuhr.org>)
Responses Re: PQexecParams and CURSOR
List pgsql-general

On Mon, Jan 17, 2005 at 11:28:57AM +0100, Laurent Marzullo wrote:

> >         // res = PQexec( conn , "FETCH 1 FROM MY_CURSOR" );

> The above should work if you uncomment it and comment out or remove
> the other two attempts to execute FETCH.

On my machine (2.6.7-gentoo-r9) and postgreSQL (postmaster --version) :
7.4.6

the command above gave:
FETCH failed: ERROR:  no value found for parameter 1

> >         /*
> >         res = PQexecParams(conn,
> >                 "FETCH 1 FROM MY_CURSOR",
> >                 0,
> >                 NULL,
> >                 NULL,
> >                 NULL,
> >                 NULL,
> >                 0);
> >         */

> The above should also work if you uncomment it and comment out or
> remove the other two.

This one alose gave the same result as the preceding one:

FETCH failed: ERROR:  no value found for parameter 1


My I install a version greater than 7.4.6 ?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/


pgsql-general by date:

Previous
From: Bo Lorentsen
Date:
Subject: Re: Index optimization ?
Next
From: Bo Lorentsen
Date:
Subject: Re: Index optimization ?