github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/eval/infinity (about) 1 eval 2 power(0::decimal, -1) 3 ---- 4 Infinity 5 6 # Infinities 7 8 eval 9 'Infinity'::float 10 ---- 11 +Inf 12 13 eval 14 '+Infinity'::float 15 ---- 16 +Inf 17 18 eval 19 '-Infinity'::float 20 ---- 21 -Inf 22 23 eval 24 'Inf'::float 25 ---- 26 +Inf 27 28 eval 29 '+Inf'::float 30 ---- 31 +Inf 32 33 eval 34 '-Inf'::float 35 ---- 36 -Inf 37 38 eval 39 'Inf'::float(4) 40 ---- 41 +Inf 42 43 eval 44 '-Inf'::real 45 ---- 46 -Inf 47 48 eval 49 '+Infinity'::double precision 50 ---- 51 +Inf 52 53 eval 54 '+Inf'::float < 1.0 55 ---- 56 false 57 58 eval 59 '+Inf'::float <= 1.0 60 ---- 61 false 62 63 eval 64 '+Inf'::float = 1.0 65 ---- 66 false 67 68 eval 69 '+Inf'::float > 1.0 70 ---- 71 true 72 73 eval 74 '+Inf'::float >= 1.0 75 ---- 76 true 77 78 eval 79 '-Inf'::float < 1.0 80 ---- 81 true 82 83 eval 84 '-Inf'::float <= 1.0 85 ---- 86 true 87 88 eval 89 '-Inf'::float = 1.0 90 ---- 91 false 92 93 eval 94 '-Inf'::float > 1.0 95 ---- 96 false 97 98 eval 99 '-Inf'::float >= 1.0 100 ---- 101 false 102 103 eval 104 '-Inf'::float < '+Inf'::float 105 ---- 106 true 107 108 eval 109 '-Inf'::float <= '+Inf'::float 110 ---- 111 true 112 113 eval 114 '-Inf'::float = '+Inf'::float 115 ---- 116 false 117 118 eval 119 '-Inf'::float > '+Inf'::float 120 ---- 121 false 122 123 eval 124 '-Inf'::float >= '+Inf'::float 125 ---- 126 false 127 128 eval 129 'Infinity'::decimal 130 ---- 131 Infinity 132 133 eval 134 '+Infinity'::decimal 135 ---- 136 Infinity 137 138 eval 139 '-Infinity'::decimal 140 ---- 141 -Infinity 142 143 eval 144 'Inf'::decimal 145 ---- 146 Infinity 147 148 eval 149 '+Inf'::decimal 150 ---- 151 Infinity 152 153 eval 154 '-Inf'::decimal 155 ---- 156 -Infinity 157 158 eval 159 'Inf'::decimal(4) 160 ---- 161 Infinity 162 163 eval 164 '+Inf'::decimal < 1.0 165 ---- 166 false 167 168 eval 169 '+Inf'::decimal <= 1.0 170 ---- 171 false 172 173 eval 174 '+Inf'::decimal = 1.0 175 ---- 176 false 177 178 eval 179 '+Inf'::decimal > 1.0 180 ---- 181 true 182 183 eval 184 '+Inf'::decimal >= 1.0 185 ---- 186 true 187 188 eval 189 '-Inf'::decimal < 1.0 190 ---- 191 true 192 193 eval 194 '-Inf'::decimal <= 1.0 195 ---- 196 true 197 198 eval 199 '-Inf'::decimal = 1.0 200 ---- 201 false 202 203 eval 204 '-Inf'::decimal > 1.0 205 ---- 206 false 207 208 eval 209 '-Inf'::decimal >= 1.0 210 ---- 211 false 212 213 eval 214 '-Inf'::decimal < '+Inf'::decimal 215 ---- 216 true 217 218 eval 219 '-Inf'::decimal <= '+Inf'::decimal 220 ---- 221 true 222 223 eval 224 '-Inf'::decimal = '+Inf'::decimal 225 ---- 226 false 227 228 eval 229 '-Inf'::decimal > '+Inf'::decimal 230 ---- 231 false 232 233 eval 234 '-Inf'::decimal >= '+Inf'::decimal 235 ---- 236 false 237 238 eval 239 'Inf'::decimal::float 240 ---- 241 +Inf 242 243 eval 244 'Inf'::float::decimal 245 ---- 246 Infinity