I am try a update more case this is my example:
set f1=(CASE f1
WHEN f1 '24' then '0'
WHEN f1 '25' then '1'
But is no is ok.
Someone can help me.
Read the vertica documentation for the two versions of the CASE expression. You are obviously making a "surprising" mix of the two.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.