intfield = 50
50
intfield <> 50
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 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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
intfield > 90
91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
intfield >= 94
94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
intfield < 7
1 2 3 4 5 6
intfield <= 9
1 2 3 4 5 6 7 8 9
floatfield = 21.1
21
floatfield <> 32.2
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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
floatfield > 80.7
81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
floatfield >= 90.1
90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
floatfield < 4.0
1 2 3
floatfield <= 5.1
1 2 3 4 5
floatfield + 1.0 = 21.1
20
floatfield - 0.1 = 30
30
floatfield * 2 = 60.2
30
floatfield / 2 = 1.05
2
floatfield % 2 between 0.0999 and 0.100001
2 4 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 42 44 46 48 50 52 54 56 58 60 62 64 66 68 70 72 74 76 78 80 82 84 86 88 90 92 94 96 98 100 102 104 106 108 110 112
intfield ^ 2 = 9
3
intfield between 1 and 2
1 2
textfield = 'item_1'
1
textfield <> 'item_2'
1 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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
textfield > 'item_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 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
textfield >= 'item_2'
2 3 4 5 6 7 8 9 20 21 22 23 24 25 26 27 28 29 30 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
textfield < 'item_3'
1 2 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 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
textfield <= 'item_3'
1 2 3 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 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
in(textfield, ('item_1', 'item_3', 'Item_50', 'itém_100'))
1 3 50 100
like(textfield, 'item_%')
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
like(textfield, 'Item_%')
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
like(textfield, 'itém_%')
30 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
casei(textfield) = 'item_40'
40
accenti(textfield) = 'item_100'
100
boolfield = true
2 4 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 42 44 46 48 50 52 54 56 58 60 62 64 66 68 70 72 74 76 78 80 82 84 86 88 90 92 94 96 98 100 102 104 106 108 110 112
boolfield <> false
2 4 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 42 44 46 48 50 52 54 56 58 60 62 64 66 68 70 72 74 76 78 80 82 84 86 88 90 92 94 96 98 100 102 104 106 108 110 112
boolfield > false
2 4 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 42 44 46 48 50 52 54 56 58 60 62 64 66 68 70 72 74 76 78 80 82 84 86 88 90 92 94 96 98 100 102 104 106 108 110 112
boolfield >= false
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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
boolfield < true
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41 43 45 47 49 51 53 55 57 59 61 63 65 67 69 71 73 75 77 79 81 83 85 87 89 91 93 95 97 99 101 103 105 107 109 111
boolfield <= true
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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
s_equals(geom, POLYGON((-164.20711184457008 -62.64591531654267,-172.10355592228504 -48.968872974814005,-187.89644407771496 -48.968872974814005,-195.79288815542992 -62.64591531654267,-187.89644407771496 -76.32295765827133,-172.10355592228504 -76.32295765827133,-164.20711184457008 -62.64591531654267)))
107
s_intersects(geom, POLYGON((-164.20711184457008 -62.64591531654267,-172.10355592228504 -48.968872974814005,-187.89644407771496 -48.968872974814005,-195.79288815542992 -62.64591531654267,-187.89644407771496 -76.32295765827133,-172.10355592228504 -76.32295765827133,-164.20711184457008 -62.64591531654267)))
99 100 106 107 108
s_disjoint(geom, POLYGON((-164.20711184457008 -62.64591531654267,-172.10355592228504 -48.968872974814005,-187.89644407771496 -48.968872974814005,-195.79288815542992 -62.64591531654267,-187.89644407771496 -76.32295765827133,-172.10355592228504 -76.32295765827133,-164.20711184457008 -62.64591531654267)))
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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 101 102 103 104 105 109 110 111 112
s_touches(geom, POLYGON((-164.20711184457008 -62.64591531654267,-172.10355592228504 -48.968872974814005,-187.89644407771496 -48.968872974814005,-195.79288815542992 -62.64591531654267,-187.89644407771496 -76.32295765827133,-172.10355592228504 -76.32295765827133,-164.20711184457008 -62.64591531654267)))
106 108
s_within(geom, POLYGON((-164.20711184457008 -62.64591531654267,-172.10355592228504 -48.968872974814005,-187.89644407771496 -48.968872974814005,-195.79288815542992 -62.64591531654267,-187.89644407771496 -76.32295765827133,-172.10355592228504 -76.32295765827133,-164.20711184457008 -62.64591531654267)))
107
s_overlaps(geom, POLYGON((-164.20711184457008 -62.64591531654267,-172.10355592228504 -48.968872974814005,-187.89644407771496 -48.968872974814005,-195.79288815542992 -62.64591531654267,-187.89644407771496 -76.32295765827133,-172.10355592228504 -76.32295765827133,-164.20711184457008 -62.64591531654267)))
99 100
s_crosses(geom, LINESTRING(-170 -90, -170 90))
99 100 101 102 103 104 105 106 107 108 109 110 111 112
s_contains(geom, POLYGON((-164.20711184457008 -62.64591531654267,-172.10355592228504 -48.968872974814005,-187.89644407771496 -48.968872974814005,-195.79288815542992 -62.64591531654267,-187.89644407771496 -76.32295765827133,-172.10355592228504 -76.32295765827133,-164.20711184457008 -62.64591531654267)))
107
datefield = DATE('2020-01-02')
1
datefield <> DATE('2020-01-02')
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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
datefield > DATE('2020-03-20')
80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
datefield >= DATE('2020-03-20')
79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
datefield < DATE('2020-01-04')
1 2
datefield <= DATE('2020-01-04')
1 2 3
ts_start = DATE('2020-01-02')
1
ts_start <> DATE('2020-01-02')
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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
ts_start > DATE('2020-03-20')
80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
ts_start >= DATE('2020-03-20')
79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
ts_start < DATE('2020-01-04')
1 2
ts_start <= DATE('2020-01-04')
1 2 3
datefield = TIMESTAMP('2020-01-02T00:00:00Z')
1
datefield <> TIMESTAMP('2020-01-02T00:00:00Z')
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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
datefield > TIMESTAMP('2020-03-20T00:00:00Z')
80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
datefield >= TIMESTAMP('2020-03-20T00:00:00Z')
79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
datefield < TIMESTAMP('2020-01-04T00:00:00Z')
1 2
datefield <= TIMESTAMP('2020-01-04T00:00:00Z')
1 2 3
ts_start = TIMESTAMP('2020-01-02T00:00:00Z')
1
ts_start <> TIMESTAMP('2020-01-02T00:00:00Z')
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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
ts_start > TIMESTAMP('2020-03-20T00:00:00Z')
80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
ts_start >= TIMESTAMP('2020-03-20T00:00:00Z')
79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
ts_start < TIMESTAMP('2020-01-04T00:00:00Z')
1 2
ts_start <= TIMESTAMP('2020-01-04T00:00:00Z')
1 2 3
t_before(ts_start, DATE('2020-02-01'))
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
t_before(ts_start, TIMESTAMP('2020-02-01T00:00:00Z'))
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
t_before(ts_start, interval('2020-02-01T00:00:00Z', '2020-05-01T00:00:00Z'))
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
t_before(DATE('2020-04-01'), ts_start)
92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_before(TIMESTAMP('2020-04-01T00:00:00Z'), ts_start)
92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_before(interval('2019-04-01T00:00:00Z', '2020-03-01T00:00:00Z'), ts_start)
61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_before(interval(ts_start, ts_end), interval('2020-03-01T00:00:00Z', '2020-05-01T00:00:00Z'))
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
t_before(interval('2019-04-01T00:00:00Z', '2020-02-01T00:00:00Z'), interval(ts_start, ts_end))
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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_after(DATE('2020-02-01'), ts_start)
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
t_after(TIMESTAMP('2020-02-01T00:00:00Z'), ts_start)
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
t_after(interval('2020-02-01T00:00:00Z', '2020-05-01T00:00:00Z'), ts_start)
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
t_after(ts_start, DATE('2020-04-01'))
92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_after(ts_start, TIMESTAMP('2020-04-01T00:00:00Z'))
92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_after(ts_start, interval('2019-04-01T00:00:00Z', '2020-03-01T00:00:00Z'))
61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_after(interval('2020-03-01T00:00:00Z', '2020-05-01T00:00:00Z'), interval(ts_start, ts_end))
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
t_after(interval(ts_start, ts_end), interval('2019-04-01T00:00:00Z', '2020-02-01T00:00:00Z'))
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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_meets(ts_end, TIMESTAMP('2020-04-01T01:00:00Z'))
91
t_meets(ts_end, interval('2020-03-01T01:00:00Z', '2020-03-01T01:00:00Z'))
60
t_meets(TIMESTAMP('2020-04-01T01:00:00Z'), ts_end)
91
t_meets(interval('2020-03-01T00:00:00Z', '2020-04-01T01:00:00Z'), ts_end)
91
t_meets(interval(ts_start, ts_end), interval('2020-04-01T01:00:00Z', '2020-05-01T00:00:00Z'))
91
t_meets(interval('2020-03-01T00:00:00Z', '2020-04-01T00:00:00Z'), interval(ts_start, ts_end))
91
t_metby(TIMESTAMP('2020-04-01T01:00:00Z'), ts_end)
91
t_metby(interval('2020-03-01T01:00:00Z', '2020-03-01T01:00:00Z'), ts_end)
60
t_metby(ts_end, TIMESTAMP('2020-04-01T01:00:00Z'))
91
t_metby(ts_end, interval('2020-03-01T00:00:00Z', '2020-04-01T01:00:00Z'))
91
t_metby(interval('2020-04-01T01:00:00Z', '2020-05-01T00:00:00Z'), interval(ts_start, ts_end))
91
t_metby(interval(ts_start, ts_end), interval('2020-03-01T00:00:00Z', '2020-04-01T00:00:00Z'))
91
t_overlaps(ts_start, interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'))
92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_overlaps(TIMESTAMP('2020-02-15T00:30:00Z'), interval(ts_start, ts_end))
45
t_overlaps(interval(ts_start, ts_end), interval('2020-03-01T00:00:30Z', '2020-03-05T00:00:00Z'))
60 61 62 63
t_overlaps(interval('2020-03-01T00:00:00Z', '2020-04-01T00:30:00Z'), interval(ts_start, ts_end))
91
t_overlappedby(interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'), ts_start)
92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_overlappedby(interval(ts_start, ts_end), TIMESTAMP('2020-02-15T00:30:00Z'))
45
t_overlappedby(interval('2020-03-01T00:00:30Z', '2020-03-05T00:00:00Z'), interval(ts_start, ts_end))
60 61 62 63
t_overlappedby(interval(ts_start, ts_end), interval('2020-03-01T00:00:00Z', '2020-04-01T00:30:00Z'))
91
t_starts(TIMESTAMP('2020-04-01T00:00:00Z'), interval(ts_start, ts_end))
91
t_starts(interval(ts_start, ts_end), interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'))
91
t_starts(interval('2020-04-01T00:00:00Z', '2020-04-01T00:30:00Z'), interval(ts_start, ts_end))
91
t_startedby(interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'), ts_start)
91
t_startedby(interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'), interval(ts_start, ts_end))
91
t_startedby(interval(ts_start, ts_end), interval('2020-04-01T00:00:00Z', '2020-04-01T00:30:00Z'))
91
t_during(ts_start, interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'))
92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_during(TIMESTAMP('2020-04-15T00:00:30Z'), interval(ts_start, ts_end))
105
t_during(interval(ts_start, ts_end), interval('2020-04-01T00:00:20Z', '2020-04-03T00:00:40Z'))
92
t_during(interval('2020-04-01T00:00:20Z', '2020-04-01T00:00:40Z'), interval(ts_start, ts_end))
91
t_contains(interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'), ts_start)
92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_contains(interval(ts_start, ts_end), TIMESTAMP('2020-04-15T00:00:30Z'))
105
t_contains(interval('2020-04-01T00:00:20Z', '2020-04-03T00:00:40Z'), interval(ts_start, ts_end))
92
t_contains(interval(ts_start, ts_end), interval('2020-04-01T00:00:20Z', '2020-04-01T00:00:40Z'))
91
t_finishes(TIMESTAMP('2020-04-01T01:00:00Z'), interval(ts_start, ts_end))
91
t_finishes(interval(ts_start, ts_end), interval('2020-03-01T00:00:00Z', '2020-04-01T01:00:00Z'))
91
t_finishes(interval('2020-04-01T00:00:20Z', '2020-04-01T01:00:00Z'), interval(ts_start, ts_end))
91
t_finishedby(interval(ts_start, ts_end), TIMESTAMP('2020-04-01T01:00:00Z'))
91
t_finishedby(interval('2020-03-01T00:00:00Z', '2020-04-01T01:00:00Z'), interval(ts_start, ts_end))
91
t_finishedby(interval(ts_start, ts_end), interval('2020-04-01T00:00:20Z', '2020-04-01T01:00:00Z'))
91
t_equals(ts_start, TIMESTAMP('2020-04-01T00:00:00Z'))
91
t_equals(TIMESTAMP('2020-04-01T00:00:00Z'), ts_start)
91
t_equals(interval(ts_start, ts_end), interval('2020-04-01T00:00:00Z', '2020-04-01T01:00:00Z'))
91
t_equals(interval('2020-04-01T00:00:00Z', '2020-04-01T01:00:00Z'), interval(ts_start, ts_end))
91
t_disjoint(ts_start, interval('2020-01-01T00:00:00Z', '2020-02-01T00:00:00Z'))
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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_disjoint(interval('2020-01-01T00:00:00Z', '2020-04-01T00:00:00Z'), ts_start)
92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_disjoint(interval(ts_start, ts_end), interval('2020-01-01T00:00:00Z', '2020-03-01T00:00:00Z'))
61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_disjoint(interval('2020-04-01T00:00:00Z', '2020-05-01T00:00:00Z'), interval(ts_start, ts_end))
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 79 80 81 82 83 84 85 86 87 88 89 90
boolfield and true
2 4 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 42 44 46 48 50 52 54 56 58 60 62 64 66 68 70 72 74 76 78 80 82 84 86 88 90 92 94 96 98 100 102 104 106 108 110 112
boolfield or false
2 4 6 8 10 12 14 16 18 20 22 24 26 28 30 32 34 36 38 40 42 44 46 48 50 52 54 56 58 60 62 64 66 68 70 72 74 76 78 80 82 84 86 88 90 92 94 96 98 100 102 104 106 108 110 112
not boolfield
1 3 5 7 9 11 13 15 17 19 21 23 25 27 29 31 33 35 37 39 41 43 45 47 49 51 53 55 57 59 61 63 65 67 69 71 73 75 77 79 81 83 85 87 89 91 93 95 97 99 101 103 105 107 109 111
intfield > 1 and floatfield < 5.0
2 3 4
(textfield = 'item_2' or textfield = 'item_3') and boolfield = true
2
not (intfield <= 2) or (boolfield and floatfield >= 2.0)
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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
floatfield between -23 and 40 and in(textfield, 'item_2', 'item_3')
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
s_intersects(geom, POINT(-93 45)) or s_disjoint(geom, POINT(-93 45))
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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
t_before(interval(ts_start, ts_end), interval('2020-01-10T00:00:00Z','2022-02-01T00:00:00Z')) and not boolfield
1 3 5 7
a_equals(intarrayfield, (1, 2, 3))
1
a_equals((1, 2, 3), intarrayfield)
1
a_contains(intarrayfield, (2, 3))
1 2
a_contains((1, 2, 3, 4), intarrayfield)
1 2
a_containedby(intarrayfield, (1, 2, 3, 4))
1 2
a_containedby((1, 2), intarrayfield)
1
a_overlaps(intarrayfield, (2, 4))
1 2 3 4
a_overlaps((2, 4), intarrayfield)
1 2 3 4
nfield is null
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 29 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112
nfield = true
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
nfield <> true
25 26 27 28
nfield is not null
25 26 27 28 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
not(nfield = true)
25 26 27 28