update y case
Good morning.
I am try a update more case this is my example:
update table1
set f1=(CASE f1
WHEN f1 '24' then '0'
WHEN f1 '25' then '1'
END)
But is no is ok.
Someone can help me.
Thanks.
0
Good morning.
I am try a update more case this is my example:
update table1
set f1=(CASE f1
WHEN f1 '24' then '0'
WHEN f1 '25' then '1'
END)
But is no is ok.
Someone can help me.
Thanks.
Comments
Read the vertica documentation for the two versions of the CASE expression. You are obviously making a "surprising" mix of the two.
ok ,tranks
solved