On Wed, 17 Sep 2008, Emi Lu wrote: > 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?
I think we'll need to see a complete example with table definitions and sample data because it does appear to work for me in simple tests. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
