Re: prepared query plan did not update - Mailing list pgsql-sql

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.