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

From Emi Lu
Subject prepared query plan did not update
Date
Msg-id 48D1526A.2050709@encs.concordia.ca
Whole thread Raw
Responses Re: prepared query plan did not update  ("Igor Neyman" <ineyman@perceptron.com>)
Re: prepared query plan did not update  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-sql
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' ;
EXECUTE pname( 'value' )



Could someone tell me where I did wrong please?

Thanks alot!




pgsql-sql by date:

Previous
From: "Raphael Bauduin"
Date:
Subject: Re: Trigger Procedure Error: NEW used in query that is not in a rule
Next
From: "Igor Neyman"
Date:
Subject: Re: prepared query plan did not update