prepared query plan did not update

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: prepared query plan did not update
Date: 2008-09-17 18:54:34
Message-ID: 48D1526A.2050709@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Igor Neyman 2008-09-17 19:28:55 Re: prepared query plan did not update
Previous Message Raphael Bauduin 2008-09-17 17:09:47 Re: Trigger Procedure Error: NEW used in query that is not in a rule