Skip to main content

update y case

  • August 24, 2017
  • 3 replies
  • 13 views

ismael
Forum|alt.badge.img+1
  • Participating Frequently

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.

3 replies

marcothesane
Forum|alt.badge.img+1
  • Participating Frequently
  • August 24, 2017

Read the vertica documentation for the two versions of the CASE expression. You are obviously making a "surprising" mix of the two.


ismael
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • August 24, 2017

ok ,tranks


ismael
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • August 24, 2017

solved