hello,
i'd like to combine to clauses of my case statement, and I do this:
case check when value1 //do something when value2 //do something (the same as in the first when) end
But how can I combine the two "when"-s. It is redundant to write the same code to "do something"
I tried to find the syntax, but couldn't. I tried something like:
case check when value1 when value2 //do the thing end
but this only works when check = value2
Thanks!