> 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?
>
>
>
>
>
> WHERE col1 AND
> col2 = '$1' ;
> Are you looking for both: col1 and col2 - to be equal to '$1'?
> Then it should be:
> WHERE col1 = '$1' AND
> col2 = '$1';
Not exactly, col1 is boolean value
WHERE col1 = true AND
col2 = '$1';