Using case in select statement. about sqlpp11 HOT 4 CLOSED

Today this is not possible, but it is on my personal wish list. It should not be that hard to do.

from sqlpp11.

Ok I will do two requests for now and do the test in the code. Let me know if I can be of any help.

from sqlpp11.

Hi,

please checkout the develop branch:

case_when(condition).then(A).else_(B)

Please note:

• there has to be exactly one condition, one then, one else, i.e. there cannot be several when/then combinations, and the else_ is not optional
• there is no case(variable).when(value).then...

Let me know if it works for you.

Best,

Roland

from sqlpp11.

case_when(condition).then(expression).else_(expression) is now supported by release-0.35

from sqlpp11.