Skip to content

Case when or If else isn't working #254

@brachipa

Description

@brachipa

Trying to run sql with case when syntax

SELECT     
      CASE 
          WHEN event = 'ABC' AND THEN '1'
          WHEN event = 'XYZ' AND THEN '2'
      END AS ExpireOn
FROM some_table

Looks like it isn't supported.

I see only if examples:

email IF email NOT IN ("hello")

But what should I do if I need else option.

maybe you have even a workaround?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions