I tried to use prepared query plan to update columns, but it did not
update at all.
PREPARE pname(varchar) AS
SET col1 = false
WHERE col1 AND
col2 = '$1' ;
EXECUTE pname( 'value' )
Could someone tell me where I did wrong please?
pgsql-sql by date
|Next:||From: Igor Neyman||Date: 2008-09-17 19:28:55|
|Subject: Re: prepared query plan did not update |
|Previous:||From: Raphael Bauduin||Date: 2008-09-17 17:09:47|
|Subject: Re: Trigger Procedure Error: NEW used in query that is not in a rule|