Re: CURSORs and selects with parameters

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Dan Sugalski <dan(at)sidhe(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: CURSORs and selects with parameters
Date: 2005-02-15 19:50:57
Message-ID: 20050215195057.GA12898@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 15, 2005 at 02:32:56PM -0500, Dan Sugalski wrote:
>
> I've got some code that uses PQexecParams and does the equivalent of:
>
> DECLARE a_cursor CURSOR FOR SELECT foo, bar FROM baz WHERE field = $1
> FETCH NEXT a_cursor
>
> but when I get to the FETCH I'm getting back the error:
>
> ERROR: no value found for parameter 1

What version of PostgreSQL are you using? I think this is fixed
in 8.0.

http://archives.postgresql.org/pgsql-general/2005-01/msg00812.php

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Sugalski 2005-02-15 19:55:23 Re: CURSORs and selects with parameters
Previous Message Dan Sugalski 2005-02-15 19:32:56 CURSORs and selects with parameters