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/ ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
