blob: 6d4a6349b2f77f426477176be3bd7df76014e3ef (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
--
-- case.sql
--
-- Test the case statement
--
-- Simplest examples without involving tables
--
SELECT '' AS "One",
CASE
WHEN 1 < 2 THEN 3
END AS "One only = 3";
SELECT '' AS "One",
CASE
WHEN 1 > 2 THEN 3
END AS "One only = Null";
SELECT '' AS "One",
CASE
WHEN 1 < 2 THEN 3
ELSE 4
END AS "One with default = 3";
SELECT '' AS "One",
CASE
WHEN 1 > 2 THEN 3
ELSE 4
END AS "One with default = 4";
SELECT '' AS "One",
CASE
WHEN 1 > 2 THEN 3
WHEN 4 < 5 THEN 6
ELSE 7
END AS "Two with default = 6";
--
-- Examples of targets involving tables
--
SELECT '' AS "Five",
CASE
WHEN f1 >= 0 THEN f1
END AS ">= 0 or Null"
FROM INT4_TBL;
SELECT '' AS "Five",
CASE WHEN f1 >= 0 THEN (f1 - f1)
ELSE f1
END AS "Simplest Math"
FROM INT4_TBL;
SELECT '' AS "Five", f1 AS "Value",
CASE WHEN (f1 < 0) THEN 'small'
WHEN (f1 = 0) THEN 'zero'
WHEN (f1 = 1) THEN 'one'
WHEN (f1 = 2) THEN 'two'
ELSE 'big'
END AS "Category"
FROM INT4_TBL;
/*
SELECT '' AS "Five",
CASE WHEN ((f1 < 0) or (i < 0)) THEN 'small'
WHEN ((f1 = 0) or (i = 0)) THEN 'zero'
WHEN ((f1 = 1) or (i = 1)) THEN 'one'
WHEN ((f1 = 2) or (i = 2)) THEN 'two'
ELSE 'big'
END AS "Category"
FROM INT4_TBL;
*/
--
-- Examples of qualifications involving tables
--
|
