Re: prepared query plan did not update

Stephan Szabo wrote:
> On Wed, 17 Sep 2008, Emi Lu wrote:
>
>> Good morning,
>>
>> I tried to use prepared query plan to update columns, but it did not
>> update at all.
>>
>> PREPARE pname(varchar) AS
>> UPDATE t1
>> SET col1 = false
>> WHERE col1 AND
>> col2 = '$1' ;
>
> I don't think you want those quotes in the second part of the where
> clause. I'm pretty sure that means you're comparing against the literal
> string with a dollar sign and one rather than the value given at execute
> time for $1.

Do you mean:

PREPARE pname(varchar) AS
UPDATE t1
SET col1 = false
WHERE col1 AND
col2 = $1 ;

But still does not work? Strange, right?