9. Conditional Expressions

Conditional Expressions with "CASE" Part 1

DROP TABLE IF EXISTS booltest;

CREATE TABLE booltest

(a INTEGER,

b INTEGER

);

INSERT INTO booltest VALUES (1, 0);

SELECT

CASE WHEN a THEN 'true' ELSE 'false' END as boolA,

CASE WHEN b THEN 'true' ELSE 'false' END as boolB

FROM booltest;

Conditional Expressions with "CASE" Part 2

DROP TABLE IF EXISTS booltest;

CREATE TABLE booltest

(a INTEGER,

b INTEGER

);

INSERT INTO booltest VALUES (1, 0);

SELECT

CASE a WHEN 1 THEN 'true' ELSE 'false' END AS boolA,

CASE b WHEN 1 THEN 'true' ELSE 'false' END AS boolB

FROM booltest

;