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!
on 2009-05-20 16:57
on 2009-05-20 17:03
On Wed, May 20, 2009 at 04:57:08PM +0200, Pesho Petrov wrote: > end > > > But how can I combine the two "when"-s. It is redundant to write the > same code to "do something" [...] case check when value1, value2 //do something end > Thanks! --Greg
on 2009-05-20 18:57