Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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.

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.