Search Postgresql Archives

Re: PQexecParams and CURSOR

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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/


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux