github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/docs/generated/sql/operators.md (about) 1 <table><thead> 2 <tr><td><code>#</code></td><td>Return</td></tr> 3 </thead><tbody> 4 <tr><td><a href="int.html">int</a> <code>#</code> <a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> 5 <tr><td>varbit <code>#</code> varbit</td><td>varbit</td></tr> 6 </tbody></table> 7 <table><thead> 8 <tr><td><code>#></code></td><td>Return</td></tr> 9 </thead><tbody> 10 <tr><td>jsonb <code>#></code> <a href="string.html">string[]</a></td><td>jsonb</td></tr> 11 </tbody></table> 12 <table><thead> 13 <tr><td><code>#>></code></td><td>Return</td></tr> 14 </thead><tbody> 15 <tr><td>jsonb <code>#>></code> <a href="string.html">string[]</a></td><td><a href="string.html">string</a></td></tr> 16 </tbody></table> 17 <table><thead> 18 <tr><td><code>%</code></td><td>Return</td></tr> 19 </thead><tbody> 20 <tr><td><a href="decimal.html">decimal</a> <code>%</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 21 <tr><td><a href="decimal.html">decimal</a> <code>%</code> <a href="int.html">int</a></td><td><a href="decimal.html">decimal</a></td></tr> 22 <tr><td><a href="float.html">float</a> <code>%</code> <a href="float.html">float</a></td><td><a href="float.html">float</a></td></tr> 23 <tr><td><a href="int.html">int</a> <code>%</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 24 <tr><td><a href="int.html">int</a> <code>%</code> <a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> 25 </tbody></table> 26 <table><thead> 27 <tr><td><code>&</code></td><td>Return</td></tr> 28 </thead><tbody> 29 <tr><td><a href="inet.html">inet</a> <code>&</code> <a href="inet.html">inet</a></td><td><a href="inet.html">inet</a></td></tr> 30 <tr><td><a href="int.html">int</a> <code>&</code> <a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> 31 <tr><td>varbit <code>&</code> varbit</td><td>varbit</td></tr> 32 </tbody></table> 33 <table><thead> 34 <tr><td><code>&&</code></td><td>Return</td></tr> 35 </thead><tbody> 36 <tr><td>anyelement <code>&&</code> anyelement</td><td><a href="bool.html">bool</a></td></tr> 37 <tr><td><a href="inet.html">inet</a> <code>&&</code> <a href="inet.html">inet</a></td><td><a href="bool.html">bool</a></td></tr> 38 </tbody></table> 39 <table><thead> 40 <tr><td><code>*</code></td><td>Return</td></tr> 41 </thead><tbody> 42 <tr><td><a href="decimal.html">decimal</a> <code>*</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 43 <tr><td><a href="decimal.html">decimal</a> <code>*</code> <a href="int.html">int</a></td><td><a href="decimal.html">decimal</a></td></tr> 44 <tr><td><a href="decimal.html">decimal</a> <code>*</code> <a href="interval.html">interval</a></td><td><a href="interval.html">interval</a></td></tr> 45 <tr><td><a href="float.html">float</a> <code>*</code> <a href="float.html">float</a></td><td><a href="float.html">float</a></td></tr> 46 <tr><td><a href="float.html">float</a> <code>*</code> <a href="interval.html">interval</a></td><td><a href="interval.html">interval</a></td></tr> 47 <tr><td><a href="int.html">int</a> <code>*</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 48 <tr><td><a href="int.html">int</a> <code>*</code> <a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> 49 <tr><td><a href="int.html">int</a> <code>*</code> <a href="interval.html">interval</a></td><td><a href="interval.html">interval</a></td></tr> 50 <tr><td><a href="interval.html">interval</a> <code>*</code> <a href="decimal.html">decimal</a></td><td><a href="interval.html">interval</a></td></tr> 51 <tr><td><a href="interval.html">interval</a> <code>*</code> <a href="float.html">float</a></td><td><a href="interval.html">interval</a></td></tr> 52 <tr><td><a href="interval.html">interval</a> <code>*</code> <a href="int.html">int</a></td><td><a href="interval.html">interval</a></td></tr> 53 </tbody></table> 54 <table><thead> 55 <tr><td><code>+</code></td><td>Return</td></tr> 56 </thead><tbody> 57 <tr><td><a href="date.html">date</a> <code>+</code> <a href="int.html">int</a></td><td><a href="date.html">date</a></td></tr> 58 <tr><td><a href="date.html">date</a> <code>+</code> <a href="interval.html">interval</a></td><td><a href="timestamp.html">timestamp</a></td></tr> 59 <tr><td><a href="date.html">date</a> <code>+</code> <a href="time.html">time</a></td><td><a href="timestamp.html">timestamp</a></td></tr> 60 <tr><td><a href="date.html">date</a> <code>+</code> timetz</td><td><a href="timestamp.html">timestamptz</a></td></tr> 61 <tr><td><a href="decimal.html">decimal</a> <code>+</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 62 <tr><td><a href="decimal.html">decimal</a> <code>+</code> <a href="int.html">int</a></td><td><a href="decimal.html">decimal</a></td></tr> 63 <tr><td><a href="float.html">float</a> <code>+</code> <a href="float.html">float</a></td><td><a href="float.html">float</a></td></tr> 64 <tr><td><a href="inet.html">inet</a> <code>+</code> <a href="int.html">int</a></td><td><a href="inet.html">inet</a></td></tr> 65 <tr><td><a href="int.html">int</a> <code>+</code> <a href="date.html">date</a></td><td><a href="date.html">date</a></td></tr> 66 <tr><td><a href="int.html">int</a> <code>+</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 67 <tr><td><a href="int.html">int</a> <code>+</code> <a href="inet.html">inet</a></td><td><a href="inet.html">inet</a></td></tr> 68 <tr><td><a href="int.html">int</a> <code>+</code> <a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> 69 <tr><td><a href="interval.html">interval</a> <code>+</code> <a href="date.html">date</a></td><td><a href="timestamp.html">timestamp</a></td></tr> 70 <tr><td><a href="interval.html">interval</a> <code>+</code> <a href="interval.html">interval</a></td><td><a href="interval.html">interval</a></td></tr> 71 <tr><td><a href="interval.html">interval</a> <code>+</code> <a href="time.html">time</a></td><td><a href="time.html">time</a></td></tr> 72 <tr><td><a href="interval.html">interval</a> <code>+</code> <a href="timestamp.html">timestamp</a></td><td><a href="timestamp.html">timestamp</a></td></tr> 73 <tr><td><a href="interval.html">interval</a> <code>+</code> <a href="timestamp.html">timestamptz</a></td><td><a href="timestamp.html">timestamptz</a></td></tr> 74 <tr><td><a href="interval.html">interval</a> <code>+</code> timetz</td><td>timetz</td></tr> 75 <tr><td><a href="time.html">time</a> <code>+</code> <a href="date.html">date</a></td><td><a href="timestamp.html">timestamp</a></td></tr> 76 <tr><td><a href="time.html">time</a> <code>+</code> <a href="interval.html">interval</a></td><td><a href="time.html">time</a></td></tr> 77 <tr><td><a href="timestamp.html">timestamp</a> <code>+</code> <a href="interval.html">interval</a></td><td><a href="timestamp.html">timestamp</a></td></tr> 78 <tr><td><a href="timestamp.html">timestamptz</a> <code>+</code> <a href="interval.html">interval</a></td><td><a href="timestamp.html">timestamptz</a></td></tr> 79 <tr><td>timetz <code>+</code> <a href="date.html">date</a></td><td><a href="timestamp.html">timestamptz</a></td></tr> 80 <tr><td>timetz <code>+</code> <a href="interval.html">interval</a></td><td>timetz</td></tr> 81 </tbody></table> 82 <table><thead> 83 <tr><td><code>-</code></td><td>Return</td></tr> 84 </thead><tbody> 85 <tr><td><code>-</code><a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 86 <tr><td><code>-</code><a href="float.html">float</a></td><td><a href="float.html">float</a></td></tr> 87 <tr><td><code>-</code><a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> 88 <tr><td><code>-</code><a href="interval.html">interval</a></td><td><a href="interval.html">interval</a></td></tr> 89 <tr><td><a href="date.html">date</a> <code>-</code> <a href="date.html">date</a></td><td><a href="int.html">int</a></td></tr> 90 <tr><td><a href="date.html">date</a> <code>-</code> <a href="int.html">int</a></td><td><a href="date.html">date</a></td></tr> 91 <tr><td><a href="date.html">date</a> <code>-</code> <a href="interval.html">interval</a></td><td><a href="timestamp.html">timestamp</a></td></tr> 92 <tr><td><a href="date.html">date</a> <code>-</code> <a href="time.html">time</a></td><td><a href="timestamp.html">timestamp</a></td></tr> 93 <tr><td><a href="decimal.html">decimal</a> <code>-</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 94 <tr><td><a href="decimal.html">decimal</a> <code>-</code> <a href="int.html">int</a></td><td><a href="decimal.html">decimal</a></td></tr> 95 <tr><td><a href="float.html">float</a> <code>-</code> <a href="float.html">float</a></td><td><a href="float.html">float</a></td></tr> 96 <tr><td><a href="inet.html">inet</a> <code>-</code> <a href="inet.html">inet</a></td><td><a href="int.html">int</a></td></tr> 97 <tr><td><a href="inet.html">inet</a> <code>-</code> <a href="int.html">int</a></td><td><a href="inet.html">inet</a></td></tr> 98 <tr><td><a href="int.html">int</a> <code>-</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 99 <tr><td><a href="int.html">int</a> <code>-</code> <a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> 100 <tr><td><a href="interval.html">interval</a> <code>-</code> <a href="interval.html">interval</a></td><td><a href="interval.html">interval</a></td></tr> 101 <tr><td>jsonb <code>-</code> <a href="int.html">int</a></td><td>jsonb</td></tr> 102 <tr><td>jsonb <code>-</code> <a href="string.html">string</a></td><td>jsonb</td></tr> 103 <tr><td>jsonb <code>-</code> <a href="string.html">string[]</a></td><td>jsonb</td></tr> 104 <tr><td><a href="time.html">time</a> <code>-</code> <a href="interval.html">interval</a></td><td><a href="time.html">time</a></td></tr> 105 <tr><td><a href="time.html">time</a> <code>-</code> <a href="time.html">time</a></td><td><a href="interval.html">interval</a></td></tr> 106 <tr><td><a href="timestamp.html">timestamp</a> <code>-</code> <a href="interval.html">interval</a></td><td><a href="timestamp.html">timestamp</a></td></tr> 107 <tr><td><a href="timestamp.html">timestamp</a> <code>-</code> <a href="timestamp.html">timestamp</a></td><td><a href="interval.html">interval</a></td></tr> 108 <tr><td><a href="timestamp.html">timestamp</a> <code>-</code> <a href="timestamp.html">timestamptz</a></td><td><a href="interval.html">interval</a></td></tr> 109 <tr><td><a href="timestamp.html">timestamptz</a> <code>-</code> <a href="interval.html">interval</a></td><td><a href="timestamp.html">timestamptz</a></td></tr> 110 <tr><td><a href="timestamp.html">timestamptz</a> <code>-</code> <a href="timestamp.html">timestamp</a></td><td><a href="interval.html">interval</a></td></tr> 111 <tr><td><a href="timestamp.html">timestamptz</a> <code>-</code> <a href="timestamp.html">timestamptz</a></td><td><a href="interval.html">interval</a></td></tr> 112 <tr><td>timetz <code>-</code> <a href="interval.html">interval</a></td><td>timetz</td></tr> 113 </tbody></table> 114 <table><thead> 115 <tr><td><code>-></code></td><td>Return</td></tr> 116 </thead><tbody> 117 <tr><td>jsonb <code>-></code> <a href="int.html">int</a></td><td>jsonb</td></tr> 118 <tr><td>jsonb <code>-></code> <a href="string.html">string</a></td><td>jsonb</td></tr> 119 </tbody></table> 120 <table><thead> 121 <tr><td><code>->></code></td><td>Return</td></tr> 122 </thead><tbody> 123 <tr><td>jsonb <code>->></code> <a href="int.html">int</a></td><td><a href="string.html">string</a></td></tr> 124 <tr><td>jsonb <code>->></code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> 125 </tbody></table> 126 <table><thead> 127 <tr><td><code>/</code></td><td>Return</td></tr> 128 </thead><tbody> 129 <tr><td><a href="decimal.html">decimal</a> <code>/</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 130 <tr><td><a href="decimal.html">decimal</a> <code>/</code> <a href="int.html">int</a></td><td><a href="decimal.html">decimal</a></td></tr> 131 <tr><td><a href="float.html">float</a> <code>/</code> <a href="float.html">float</a></td><td><a href="float.html">float</a></td></tr> 132 <tr><td><a href="int.html">int</a> <code>/</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 133 <tr><td><a href="int.html">int</a> <code>/</code> <a href="int.html">int</a></td><td><a href="decimal.html">decimal</a></td></tr> 134 <tr><td><a href="interval.html">interval</a> <code>/</code> <a href="float.html">float</a></td><td><a href="interval.html">interval</a></td></tr> 135 <tr><td><a href="interval.html">interval</a> <code>/</code> <a href="int.html">int</a></td><td><a href="interval.html">interval</a></td></tr> 136 </tbody></table> 137 <table><thead> 138 <tr><td><code>//</code></td><td>Return</td></tr> 139 </thead><tbody> 140 <tr><td><a href="decimal.html">decimal</a> <code>//</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 141 <tr><td><a href="decimal.html">decimal</a> <code>//</code> <a href="int.html">int</a></td><td><a href="decimal.html">decimal</a></td></tr> 142 <tr><td><a href="float.html">float</a> <code>//</code> <a href="float.html">float</a></td><td><a href="float.html">float</a></td></tr> 143 <tr><td><a href="int.html">int</a> <code>//</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 144 <tr><td><a href="int.html">int</a> <code>//</code> <a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> 145 </tbody></table> 146 <table><thead> 147 <tr><td><code><</code></td><td>Return</td></tr> 148 </thead><tbody> 149 <tr><td>anyenum <code><</code> anyenum</td><td><a href="bool.html">bool</a></td></tr> 150 <tr><td><a href="bool.html">bool</a> <code><</code> <a href="bool.html">bool</a></td><td><a href="bool.html">bool</a></td></tr> 151 <tr><td><a href="bool.html">bool[]</a> <code><</code> <a href="bool.html">bool[]</a></td><td><a href="bool.html">bool</a></td></tr> 152 <tr><td><a href="bytes.html">bytes</a> <code><</code> <a href="bytes.html">bytes</a></td><td><a href="bool.html">bool</a></td></tr> 153 <tr><td><a href="bytes.html">bytes[]</a> <code><</code> <a href="bytes.html">bytes[]</a></td><td><a href="bool.html">bool</a></td></tr> 154 <tr><td><a href="collatedstring.html">collatedstring</a> <code><</code> <a href="collatedstring.html">collatedstring</a></td><td><a href="bool.html">bool</a></td></tr> 155 <tr><td><a href="date.html">date</a> <code><</code> <a href="date.html">date</a></td><td><a href="bool.html">bool</a></td></tr> 156 <tr><td><a href="date.html">date</a> <code><</code> <a href="timestamp.html">timestamp</a></td><td><a href="bool.html">bool</a></td></tr> 157 <tr><td><a href="date.html">date</a> <code><</code> <a href="timestamp.html">timestamptz</a></td><td><a href="bool.html">bool</a></td></tr> 158 <tr><td><a href="date.html">date[]</a> <code><</code> <a href="date.html">date[]</a></td><td><a href="bool.html">bool</a></td></tr> 159 <tr><td><a href="decimal.html">decimal</a> <code><</code> <a href="decimal.html">decimal</a></td><td><a href="bool.html">bool</a></td></tr> 160 <tr><td><a href="decimal.html">decimal</a> <code><</code> <a href="float.html">float</a></td><td><a href="bool.html">bool</a></td></tr> 161 <tr><td><a href="decimal.html">decimal</a> <code><</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> 162 <tr><td><a href="decimal.html">decimal[]</a> <code><</code> <a href="decimal.html">decimal[]</a></td><td><a href="bool.html">bool</a></td></tr> 163 <tr><td><a href="float.html">float</a> <code><</code> <a href="decimal.html">decimal</a></td><td><a href="bool.html">bool</a></td></tr> 164 <tr><td><a href="float.html">float</a> <code><</code> <a href="float.html">float</a></td><td><a href="bool.html">bool</a></td></tr> 165 <tr><td><a href="float.html">float</a> <code><</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> 166 <tr><td><a href="float.html">float[]</a> <code><</code> <a href="float.html">float[]</a></td><td><a href="bool.html">bool</a></td></tr> 167 <tr><td>geography <code><</code> geography</td><td><a href="bool.html">bool</a></td></tr> 168 <tr><td>geometry <code><</code> geometry</td><td><a href="bool.html">bool</a></td></tr> 169 <tr><td><a href="inet.html">inet</a> <code><</code> <a href="inet.html">inet</a></td><td><a href="bool.html">bool</a></td></tr> 170 <tr><td><a href="inet.html">inet[]</a> <code><</code> <a href="inet.html">inet[]</a></td><td><a href="bool.html">bool</a></td></tr> 171 <tr><td><a href="int.html">int</a> <code><</code> <a href="decimal.html">decimal</a></td><td><a href="bool.html">bool</a></td></tr> 172 <tr><td><a href="int.html">int</a> <code><</code> <a href="float.html">float</a></td><td><a href="bool.html">bool</a></td></tr> 173 <tr><td><a href="int.html">int</a> <code><</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> 174 <tr><td><a href="int.html">int[]</a> <code><</code> <a href="int.html">int[]</a></td><td><a href="bool.html">bool</a></td></tr> 175 <tr><td><a href="interval.html">interval</a> <code><</code> <a href="interval.html">interval</a></td><td><a href="bool.html">bool</a></td></tr> 176 <tr><td><a href="interval.html">interval[]</a> <code><</code> <a href="interval.html">interval[]</a></td><td><a href="bool.html">bool</a></td></tr> 177 <tr><td>jsonb <code><</code> jsonb</td><td><a href="bool.html">bool</a></td></tr> 178 <tr><td>oid <code><</code> oid</td><td><a href="bool.html">bool</a></td></tr> 179 <tr><td><a href="string.html">string</a> <code><</code> <a href="string.html">string</a></td><td><a href="bool.html">bool</a></td></tr> 180 <tr><td><a href="string.html">string[]</a> <code><</code> <a href="string.html">string[]</a></td><td><a href="bool.html">bool</a></td></tr> 181 <tr><td><a href="time.html">time</a> <code><</code> <a href="time.html">time</a></td><td><a href="bool.html">bool</a></td></tr> 182 <tr><td><a href="time.html">time</a> <code><</code> timetz</td><td><a href="bool.html">bool</a></td></tr> 183 <tr><td><a href="time.html">time[]</a> <code><</code> <a href="time.html">time[]</a></td><td><a href="bool.html">bool</a></td></tr> 184 <tr><td><a href="timestamp.html">timestamp</a> <code><</code> <a href="date.html">date</a></td><td><a href="bool.html">bool</a></td></tr> 185 <tr><td><a href="timestamp.html">timestamp</a> <code><</code> <a href="timestamp.html">timestamp</a></td><td><a href="bool.html">bool</a></td></tr> 186 <tr><td><a href="timestamp.html">timestamp</a> <code><</code> <a href="timestamp.html">timestamptz</a></td><td><a href="bool.html">bool</a></td></tr> 187 <tr><td><a href="timestamp.html">timestamp[]</a> <code><</code> <a href="timestamp.html">timestamp[]</a></td><td><a href="bool.html">bool</a></td></tr> 188 <tr><td><a href="timestamp.html">timestamptz</a> <code><</code> <a href="date.html">date</a></td><td><a href="bool.html">bool</a></td></tr> 189 <tr><td><a href="timestamp.html">timestamptz</a> <code><</code> <a href="timestamp.html">timestamp</a></td><td><a href="bool.html">bool</a></td></tr> 190 <tr><td><a href="timestamp.html">timestamptz</a> <code><</code> <a href="timestamp.html">timestamptz</a></td><td><a href="bool.html">bool</a></td></tr> 191 <tr><td>timestamptz <code><</code> timestamptz</td><td><a href="bool.html">bool</a></td></tr> 192 <tr><td>timetz <code><</code> <a href="time.html">time</a></td><td><a href="bool.html">bool</a></td></tr> 193 <tr><td>timetz <code><</code> timetz</td><td><a href="bool.html">bool</a></td></tr> 194 <tr><td>tuple <code><</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 195 <tr><td><a href="uuid.html">uuid</a> <code><</code> <a href="uuid.html">uuid</a></td><td><a href="bool.html">bool</a></td></tr> 196 <tr><td><a href="uuid.html">uuid[]</a> <code><</code> <a href="uuid.html">uuid[]</a></td><td><a href="bool.html">bool</a></td></tr> 197 <tr><td>varbit <code><</code> varbit</td><td><a href="bool.html">bool</a></td></tr> 198 </tbody></table> 199 <table><thead> 200 <tr><td><code><<</code></td><td>Return</td></tr> 201 </thead><tbody> 202 <tr><td><a href="inet.html">inet</a> <code><<</code> <a href="inet.html">inet</a></td><td><a href="bool.html">bool</a></td></tr> 203 <tr><td><a href="int.html">int</a> <code><<</code> <a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> 204 <tr><td>varbit <code><<</code> <a href="int.html">int</a></td><td>varbit</td></tr> 205 </tbody></table> 206 <table><thead> 207 <tr><td><code><=</code></td><td>Return</td></tr> 208 </thead><tbody> 209 <tr><td>anyenum <code><=</code> anyenum</td><td><a href="bool.html">bool</a></td></tr> 210 <tr><td><a href="bool.html">bool</a> <code><=</code> <a href="bool.html">bool</a></td><td><a href="bool.html">bool</a></td></tr> 211 <tr><td><a href="bool.html">bool[]</a> <code><=</code> <a href="bool.html">bool[]</a></td><td><a href="bool.html">bool</a></td></tr> 212 <tr><td><a href="bytes.html">bytes</a> <code><=</code> <a href="bytes.html">bytes</a></td><td><a href="bool.html">bool</a></td></tr> 213 <tr><td><a href="bytes.html">bytes[]</a> <code><=</code> <a href="bytes.html">bytes[]</a></td><td><a href="bool.html">bool</a></td></tr> 214 <tr><td><a href="collatedstring.html">collatedstring</a> <code><=</code> <a href="collatedstring.html">collatedstring</a></td><td><a href="bool.html">bool</a></td></tr> 215 <tr><td><a href="date.html">date</a> <code><=</code> <a href="date.html">date</a></td><td><a href="bool.html">bool</a></td></tr> 216 <tr><td><a href="date.html">date</a> <code><=</code> <a href="timestamp.html">timestamp</a></td><td><a href="bool.html">bool</a></td></tr> 217 <tr><td><a href="date.html">date</a> <code><=</code> <a href="timestamp.html">timestamptz</a></td><td><a href="bool.html">bool</a></td></tr> 218 <tr><td><a href="date.html">date[]</a> <code><=</code> <a href="date.html">date[]</a></td><td><a href="bool.html">bool</a></td></tr> 219 <tr><td><a href="decimal.html">decimal</a> <code><=</code> <a href="decimal.html">decimal</a></td><td><a href="bool.html">bool</a></td></tr> 220 <tr><td><a href="decimal.html">decimal</a> <code><=</code> <a href="float.html">float</a></td><td><a href="bool.html">bool</a></td></tr> 221 <tr><td><a href="decimal.html">decimal</a> <code><=</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> 222 <tr><td><a href="decimal.html">decimal[]</a> <code><=</code> <a href="decimal.html">decimal[]</a></td><td><a href="bool.html">bool</a></td></tr> 223 <tr><td><a href="float.html">float</a> <code><=</code> <a href="decimal.html">decimal</a></td><td><a href="bool.html">bool</a></td></tr> 224 <tr><td><a href="float.html">float</a> <code><=</code> <a href="float.html">float</a></td><td><a href="bool.html">bool</a></td></tr> 225 <tr><td><a href="float.html">float</a> <code><=</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> 226 <tr><td><a href="float.html">float[]</a> <code><=</code> <a href="float.html">float[]</a></td><td><a href="bool.html">bool</a></td></tr> 227 <tr><td>geography <code><=</code> geography</td><td><a href="bool.html">bool</a></td></tr> 228 <tr><td>geometry <code><=</code> geometry</td><td><a href="bool.html">bool</a></td></tr> 229 <tr><td><a href="inet.html">inet</a> <code><=</code> <a href="inet.html">inet</a></td><td><a href="bool.html">bool</a></td></tr> 230 <tr><td><a href="inet.html">inet[]</a> <code><=</code> <a href="inet.html">inet[]</a></td><td><a href="bool.html">bool</a></td></tr> 231 <tr><td><a href="int.html">int</a> <code><=</code> <a href="decimal.html">decimal</a></td><td><a href="bool.html">bool</a></td></tr> 232 <tr><td><a href="int.html">int</a> <code><=</code> <a href="float.html">float</a></td><td><a href="bool.html">bool</a></td></tr> 233 <tr><td><a href="int.html">int</a> <code><=</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> 234 <tr><td><a href="int.html">int[]</a> <code><=</code> <a href="int.html">int[]</a></td><td><a href="bool.html">bool</a></td></tr> 235 <tr><td><a href="interval.html">interval</a> <code><=</code> <a href="interval.html">interval</a></td><td><a href="bool.html">bool</a></td></tr> 236 <tr><td><a href="interval.html">interval[]</a> <code><=</code> <a href="interval.html">interval[]</a></td><td><a href="bool.html">bool</a></td></tr> 237 <tr><td>jsonb <code><=</code> jsonb</td><td><a href="bool.html">bool</a></td></tr> 238 <tr><td>oid <code><=</code> oid</td><td><a href="bool.html">bool</a></td></tr> 239 <tr><td><a href="string.html">string</a> <code><=</code> <a href="string.html">string</a></td><td><a href="bool.html">bool</a></td></tr> 240 <tr><td><a href="string.html">string[]</a> <code><=</code> <a href="string.html">string[]</a></td><td><a href="bool.html">bool</a></td></tr> 241 <tr><td><a href="time.html">time</a> <code><=</code> <a href="time.html">time</a></td><td><a href="bool.html">bool</a></td></tr> 242 <tr><td><a href="time.html">time</a> <code><=</code> timetz</td><td><a href="bool.html">bool</a></td></tr> 243 <tr><td><a href="time.html">time[]</a> <code><=</code> <a href="time.html">time[]</a></td><td><a href="bool.html">bool</a></td></tr> 244 <tr><td><a href="timestamp.html">timestamp</a> <code><=</code> <a href="date.html">date</a></td><td><a href="bool.html">bool</a></td></tr> 245 <tr><td><a href="timestamp.html">timestamp</a> <code><=</code> <a href="timestamp.html">timestamp</a></td><td><a href="bool.html">bool</a></td></tr> 246 <tr><td><a href="timestamp.html">timestamp</a> <code><=</code> <a href="timestamp.html">timestamptz</a></td><td><a href="bool.html">bool</a></td></tr> 247 <tr><td><a href="timestamp.html">timestamp[]</a> <code><=</code> <a href="timestamp.html">timestamp[]</a></td><td><a href="bool.html">bool</a></td></tr> 248 <tr><td><a href="timestamp.html">timestamptz</a> <code><=</code> <a href="date.html">date</a></td><td><a href="bool.html">bool</a></td></tr> 249 <tr><td><a href="timestamp.html">timestamptz</a> <code><=</code> <a href="timestamp.html">timestamp</a></td><td><a href="bool.html">bool</a></td></tr> 250 <tr><td><a href="timestamp.html">timestamptz</a> <code><=</code> <a href="timestamp.html">timestamptz</a></td><td><a href="bool.html">bool</a></td></tr> 251 <tr><td>timestamptz <code><=</code> timestamptz</td><td><a href="bool.html">bool</a></td></tr> 252 <tr><td>timetz <code><=</code> <a href="time.html">time</a></td><td><a href="bool.html">bool</a></td></tr> 253 <tr><td>timetz <code><=</code> timetz</td><td><a href="bool.html">bool</a></td></tr> 254 <tr><td>tuple <code><=</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 255 <tr><td><a href="uuid.html">uuid</a> <code><=</code> <a href="uuid.html">uuid</a></td><td><a href="bool.html">bool</a></td></tr> 256 <tr><td><a href="uuid.html">uuid[]</a> <code><=</code> <a href="uuid.html">uuid[]</a></td><td><a href="bool.html">bool</a></td></tr> 257 <tr><td>varbit <code><=</code> varbit</td><td><a href="bool.html">bool</a></td></tr> 258 </tbody></table> 259 <table><thead> 260 <tr><td><code><@</code></td><td>Return</td></tr> 261 </thead><tbody> 262 <tr><td>anyelement <code><@</code> anyelement</td><td><a href="bool.html">bool</a></td></tr> 263 <tr><td>jsonb <code><@</code> jsonb</td><td><a href="bool.html">bool</a></td></tr> 264 </tbody></table> 265 <table><thead> 266 <tr><td><code>=</code></td><td>Return</td></tr> 267 </thead><tbody> 268 <tr><td>anyenum <code>=</code> anyenum</td><td><a href="bool.html">bool</a></td></tr> 269 <tr><td><a href="bool.html">bool</a> <code>=</code> <a href="bool.html">bool</a></td><td><a href="bool.html">bool</a></td></tr> 270 <tr><td><a href="bool.html">bool[]</a> <code>=</code> <a href="bool.html">bool[]</a></td><td><a href="bool.html">bool</a></td></tr> 271 <tr><td><a href="bytes.html">bytes</a> <code>=</code> <a href="bytes.html">bytes</a></td><td><a href="bool.html">bool</a></td></tr> 272 <tr><td><a href="bytes.html">bytes[]</a> <code>=</code> <a href="bytes.html">bytes[]</a></td><td><a href="bool.html">bool</a></td></tr> 273 <tr><td><a href="collatedstring.html">collatedstring</a> <code>=</code> <a href="collatedstring.html">collatedstring</a></td><td><a href="bool.html">bool</a></td></tr> 274 <tr><td><a href="date.html">date</a> <code>=</code> <a href="date.html">date</a></td><td><a href="bool.html">bool</a></td></tr> 275 <tr><td><a href="date.html">date</a> <code>=</code> <a href="timestamp.html">timestamp</a></td><td><a href="bool.html">bool</a></td></tr> 276 <tr><td><a href="date.html">date</a> <code>=</code> <a href="timestamp.html">timestamptz</a></td><td><a href="bool.html">bool</a></td></tr> 277 <tr><td><a href="date.html">date[]</a> <code>=</code> <a href="date.html">date[]</a></td><td><a href="bool.html">bool</a></td></tr> 278 <tr><td><a href="decimal.html">decimal</a> <code>=</code> <a href="decimal.html">decimal</a></td><td><a href="bool.html">bool</a></td></tr> 279 <tr><td><a href="decimal.html">decimal</a> <code>=</code> <a href="float.html">float</a></td><td><a href="bool.html">bool</a></td></tr> 280 <tr><td><a href="decimal.html">decimal</a> <code>=</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> 281 <tr><td><a href="decimal.html">decimal[]</a> <code>=</code> <a href="decimal.html">decimal[]</a></td><td><a href="bool.html">bool</a></td></tr> 282 <tr><td><a href="float.html">float</a> <code>=</code> <a href="decimal.html">decimal</a></td><td><a href="bool.html">bool</a></td></tr> 283 <tr><td><a href="float.html">float</a> <code>=</code> <a href="float.html">float</a></td><td><a href="bool.html">bool</a></td></tr> 284 <tr><td><a href="float.html">float</a> <code>=</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> 285 <tr><td><a href="float.html">float[]</a> <code>=</code> <a href="float.html">float[]</a></td><td><a href="bool.html">bool</a></td></tr> 286 <tr><td>geography <code>=</code> geography</td><td><a href="bool.html">bool</a></td></tr> 287 <tr><td>geometry <code>=</code> geometry</td><td><a href="bool.html">bool</a></td></tr> 288 <tr><td><a href="inet.html">inet</a> <code>=</code> <a href="inet.html">inet</a></td><td><a href="bool.html">bool</a></td></tr> 289 <tr><td><a href="inet.html">inet[]</a> <code>=</code> <a href="inet.html">inet[]</a></td><td><a href="bool.html">bool</a></td></tr> 290 <tr><td><a href="int.html">int</a> <code>=</code> <a href="decimal.html">decimal</a></td><td><a href="bool.html">bool</a></td></tr> 291 <tr><td><a href="int.html">int</a> <code>=</code> <a href="float.html">float</a></td><td><a href="bool.html">bool</a></td></tr> 292 <tr><td><a href="int.html">int</a> <code>=</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> 293 <tr><td><a href="int.html">int[]</a> <code>=</code> <a href="int.html">int[]</a></td><td><a href="bool.html">bool</a></td></tr> 294 <tr><td><a href="interval.html">interval</a> <code>=</code> <a href="interval.html">interval</a></td><td><a href="bool.html">bool</a></td></tr> 295 <tr><td><a href="interval.html">interval[]</a> <code>=</code> <a href="interval.html">interval[]</a></td><td><a href="bool.html">bool</a></td></tr> 296 <tr><td>jsonb <code>=</code> jsonb</td><td><a href="bool.html">bool</a></td></tr> 297 <tr><td>oid <code>=</code> oid</td><td><a href="bool.html">bool</a></td></tr> 298 <tr><td><a href="string.html">string</a> <code>=</code> <a href="string.html">string</a></td><td><a href="bool.html">bool</a></td></tr> 299 <tr><td><a href="string.html">string[]</a> <code>=</code> <a href="string.html">string[]</a></td><td><a href="bool.html">bool</a></td></tr> 300 <tr><td><a href="time.html">time</a> <code>=</code> <a href="time.html">time</a></td><td><a href="bool.html">bool</a></td></tr> 301 <tr><td><a href="time.html">time</a> <code>=</code> timetz</td><td><a href="bool.html">bool</a></td></tr> 302 <tr><td><a href="time.html">time[]</a> <code>=</code> <a href="time.html">time[]</a></td><td><a href="bool.html">bool</a></td></tr> 303 <tr><td><a href="timestamp.html">timestamp</a> <code>=</code> <a href="date.html">date</a></td><td><a href="bool.html">bool</a></td></tr> 304 <tr><td><a href="timestamp.html">timestamp</a> <code>=</code> <a href="timestamp.html">timestamp</a></td><td><a href="bool.html">bool</a></td></tr> 305 <tr><td><a href="timestamp.html">timestamp</a> <code>=</code> <a href="timestamp.html">timestamptz</a></td><td><a href="bool.html">bool</a></td></tr> 306 <tr><td><a href="timestamp.html">timestamp[]</a> <code>=</code> <a href="timestamp.html">timestamp[]</a></td><td><a href="bool.html">bool</a></td></tr> 307 <tr><td><a href="timestamp.html">timestamptz</a> <code>=</code> <a href="date.html">date</a></td><td><a href="bool.html">bool</a></td></tr> 308 <tr><td><a href="timestamp.html">timestamptz</a> <code>=</code> <a href="timestamp.html">timestamp</a></td><td><a href="bool.html">bool</a></td></tr> 309 <tr><td><a href="timestamp.html">timestamptz</a> <code>=</code> <a href="timestamp.html">timestamptz</a></td><td><a href="bool.html">bool</a></td></tr> 310 <tr><td>timestamptz <code>=</code> timestamptz</td><td><a href="bool.html">bool</a></td></tr> 311 <tr><td>timetz <code>=</code> <a href="time.html">time</a></td><td><a href="bool.html">bool</a></td></tr> 312 <tr><td>timetz <code>=</code> timetz</td><td><a href="bool.html">bool</a></td></tr> 313 <tr><td>tuple <code>=</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 314 <tr><td><a href="uuid.html">uuid</a> <code>=</code> <a href="uuid.html">uuid</a></td><td><a href="bool.html">bool</a></td></tr> 315 <tr><td><a href="uuid.html">uuid[]</a> <code>=</code> <a href="uuid.html">uuid[]</a></td><td><a href="bool.html">bool</a></td></tr> 316 <tr><td>varbit <code>=</code> varbit</td><td><a href="bool.html">bool</a></td></tr> 317 </tbody></table> 318 <table><thead> 319 <tr><td><code>>></code></td><td>Return</td></tr> 320 </thead><tbody> 321 <tr><td><a href="inet.html">inet</a> <code>>></code> <a href="inet.html">inet</a></td><td><a href="bool.html">bool</a></td></tr> 322 <tr><td><a href="int.html">int</a> <code>>></code> <a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> 323 <tr><td>varbit <code>>></code> <a href="int.html">int</a></td><td>varbit</td></tr> 324 </tbody></table> 325 <table><thead> 326 <tr><td><code>?</code></td><td>Return</td></tr> 327 </thead><tbody> 328 <tr><td>jsonb <code>?</code> <a href="string.html">string</a></td><td><a href="bool.html">bool</a></td></tr> 329 </tbody></table> 330 <table><thead> 331 <tr><td><code>?&</code></td><td>Return</td></tr> 332 </thead><tbody> 333 <tr><td>jsonb <code>?&</code> <a href="string.html">string[]</a></td><td><a href="bool.html">bool</a></td></tr> 334 </tbody></table> 335 <table><thead> 336 <tr><td><code>?|</code></td><td>Return</td></tr> 337 </thead><tbody> 338 <tr><td>jsonb <code>?|</code> <a href="string.html">string[]</a></td><td><a href="bool.html">bool</a></td></tr> 339 </tbody></table> 340 <table><thead> 341 <tr><td><code>@></code></td><td>Return</td></tr> 342 </thead><tbody> 343 <tr><td>anyelement <code>@></code> anyelement</td><td><a href="bool.html">bool</a></td></tr> 344 <tr><td>jsonb <code>@></code> jsonb</td><td><a href="bool.html">bool</a></td></tr> 345 </tbody></table> 346 <table><thead> 347 <tr><td><code>ILIKE</code></td><td>Return</td></tr> 348 </thead><tbody> 349 <tr><td><a href="string.html">string</a> <code>ILIKE</code> <a href="string.html">string</a></td><td><a href="bool.html">bool</a></td></tr> 350 </tbody></table> 351 <table><thead> 352 <tr><td><code>IN</code></td><td>Return</td></tr> 353 </thead><tbody> 354 <tr><td>anyenum <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 355 <tr><td><a href="bool.html">bool</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 356 <tr><td><a href="bytes.html">bytes</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 357 <tr><td><a href="collatedstring.html">collatedstring</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 358 <tr><td><a href="date.html">date</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 359 <tr><td><a href="decimal.html">decimal</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 360 <tr><td><a href="float.html">float</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 361 <tr><td>geography <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 362 <tr><td>geometry <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 363 <tr><td><a href="inet.html">inet</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 364 <tr><td><a href="int.html">int</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 365 <tr><td><a href="interval.html">interval</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 366 <tr><td>jsonb <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 367 <tr><td>oid <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 368 <tr><td><a href="string.html">string</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 369 <tr><td><a href="time.html">time</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 370 <tr><td><a href="timestamp.html">timestamp</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 371 <tr><td><a href="timestamp.html">timestamptz</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 372 <tr><td>timetz <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 373 <tr><td>tuple <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 374 <tr><td><a href="uuid.html">uuid</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 375 <tr><td>varbit <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 376 </tbody></table> 377 <table><thead> 378 <tr><td><code>IS NOT DISTINCT FROM</code></td><td>Return</td></tr> 379 </thead><tbody> 380 <tr><td>anyenum <code>IS NOT DISTINCT FROM</code> anyenum</td><td><a href="bool.html">bool</a></td></tr> 381 <tr><td><a href="bool.html">bool</a> <code>IS NOT DISTINCT FROM</code> <a href="bool.html">bool</a></td><td><a href="bool.html">bool</a></td></tr> 382 <tr><td><a href="bool.html">bool[]</a> <code>IS NOT DISTINCT FROM</code> <a href="bool.html">bool[]</a></td><td><a href="bool.html">bool</a></td></tr> 383 <tr><td><a href="bytes.html">bytes</a> <code>IS NOT DISTINCT FROM</code> <a href="bytes.html">bytes</a></td><td><a href="bool.html">bool</a></td></tr> 384 <tr><td><a href="bytes.html">bytes[]</a> <code>IS NOT DISTINCT FROM</code> <a href="bytes.html">bytes[]</a></td><td><a href="bool.html">bool</a></td></tr> 385 <tr><td><a href="collatedstring.html">collatedstring</a> <code>IS NOT DISTINCT FROM</code> <a href="collatedstring.html">collatedstring</a></td><td><a href="bool.html">bool</a></td></tr> 386 <tr><td><a href="date.html">date</a> <code>IS NOT DISTINCT FROM</code> <a href="date.html">date</a></td><td><a href="bool.html">bool</a></td></tr> 387 <tr><td><a href="date.html">date</a> <code>IS NOT DISTINCT FROM</code> <a href="timestamp.html">timestamp</a></td><td><a href="bool.html">bool</a></td></tr> 388 <tr><td><a href="date.html">date</a> <code>IS NOT DISTINCT FROM</code> <a href="timestamp.html">timestamptz</a></td><td><a href="bool.html">bool</a></td></tr> 389 <tr><td><a href="date.html">date[]</a> <code>IS NOT DISTINCT FROM</code> <a href="date.html">date[]</a></td><td><a href="bool.html">bool</a></td></tr> 390 <tr><td><a href="decimal.html">decimal</a> <code>IS NOT DISTINCT FROM</code> <a href="decimal.html">decimal</a></td><td><a href="bool.html">bool</a></td></tr> 391 <tr><td><a href="decimal.html">decimal</a> <code>IS NOT DISTINCT FROM</code> <a href="float.html">float</a></td><td><a href="bool.html">bool</a></td></tr> 392 <tr><td><a href="decimal.html">decimal</a> <code>IS NOT DISTINCT FROM</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> 393 <tr><td><a href="decimal.html">decimal[]</a> <code>IS NOT DISTINCT FROM</code> <a href="decimal.html">decimal[]</a></td><td><a href="bool.html">bool</a></td></tr> 394 <tr><td><a href="float.html">float</a> <code>IS NOT DISTINCT FROM</code> <a href="decimal.html">decimal</a></td><td><a href="bool.html">bool</a></td></tr> 395 <tr><td><a href="float.html">float</a> <code>IS NOT DISTINCT FROM</code> <a href="float.html">float</a></td><td><a href="bool.html">bool</a></td></tr> 396 <tr><td><a href="float.html">float</a> <code>IS NOT DISTINCT FROM</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> 397 <tr><td><a href="float.html">float[]</a> <code>IS NOT DISTINCT FROM</code> <a href="float.html">float[]</a></td><td><a href="bool.html">bool</a></td></tr> 398 <tr><td>geography <code>IS NOT DISTINCT FROM</code> geography</td><td><a href="bool.html">bool</a></td></tr> 399 <tr><td>geometry <code>IS NOT DISTINCT FROM</code> geometry</td><td><a href="bool.html">bool</a></td></tr> 400 <tr><td><a href="inet.html">inet</a> <code>IS NOT DISTINCT FROM</code> <a href="inet.html">inet</a></td><td><a href="bool.html">bool</a></td></tr> 401 <tr><td><a href="inet.html">inet[]</a> <code>IS NOT DISTINCT FROM</code> <a href="inet.html">inet[]</a></td><td><a href="bool.html">bool</a></td></tr> 402 <tr><td><a href="int.html">int</a> <code>IS NOT DISTINCT FROM</code> <a href="decimal.html">decimal</a></td><td><a href="bool.html">bool</a></td></tr> 403 <tr><td><a href="int.html">int</a> <code>IS NOT DISTINCT FROM</code> <a href="float.html">float</a></td><td><a href="bool.html">bool</a></td></tr> 404 <tr><td><a href="int.html">int</a> <code>IS NOT DISTINCT FROM</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> 405 <tr><td><a href="int.html">int[]</a> <code>IS NOT DISTINCT FROM</code> <a href="int.html">int[]</a></td><td><a href="bool.html">bool</a></td></tr> 406 <tr><td><a href="interval.html">interval</a> <code>IS NOT DISTINCT FROM</code> <a href="interval.html">interval</a></td><td><a href="bool.html">bool</a></td></tr> 407 <tr><td><a href="interval.html">interval[]</a> <code>IS NOT DISTINCT FROM</code> <a href="interval.html">interval[]</a></td><td><a href="bool.html">bool</a></td></tr> 408 <tr><td>jsonb <code>IS NOT DISTINCT FROM</code> jsonb</td><td><a href="bool.html">bool</a></td></tr> 409 <tr><td>oid <code>IS NOT DISTINCT FROM</code> oid</td><td><a href="bool.html">bool</a></td></tr> 410 <tr><td><a href="string.html">string</a> <code>IS NOT DISTINCT FROM</code> <a href="string.html">string</a></td><td><a href="bool.html">bool</a></td></tr> 411 <tr><td><a href="string.html">string[]</a> <code>IS NOT DISTINCT FROM</code> <a href="string.html">string[]</a></td><td><a href="bool.html">bool</a></td></tr> 412 <tr><td><a href="time.html">time</a> <code>IS NOT DISTINCT FROM</code> <a href="time.html">time</a></td><td><a href="bool.html">bool</a></td></tr> 413 <tr><td><a href="time.html">time</a> <code>IS NOT DISTINCT FROM</code> timetz</td><td><a href="bool.html">bool</a></td></tr> 414 <tr><td><a href="time.html">time[]</a> <code>IS NOT DISTINCT FROM</code> <a href="time.html">time[]</a></td><td><a href="bool.html">bool</a></td></tr> 415 <tr><td><a href="timestamp.html">timestamp</a> <code>IS NOT DISTINCT FROM</code> <a href="date.html">date</a></td><td><a href="bool.html">bool</a></td></tr> 416 <tr><td><a href="timestamp.html">timestamp</a> <code>IS NOT DISTINCT FROM</code> <a href="timestamp.html">timestamp</a></td><td><a href="bool.html">bool</a></td></tr> 417 <tr><td><a href="timestamp.html">timestamp</a> <code>IS NOT DISTINCT FROM</code> <a href="timestamp.html">timestamptz</a></td><td><a href="bool.html">bool</a></td></tr> 418 <tr><td><a href="timestamp.html">timestamp[]</a> <code>IS NOT DISTINCT FROM</code> <a href="timestamp.html">timestamp[]</a></td><td><a href="bool.html">bool</a></td></tr> 419 <tr><td><a href="timestamp.html">timestamptz</a> <code>IS NOT DISTINCT FROM</code> <a href="date.html">date</a></td><td><a href="bool.html">bool</a></td></tr> 420 <tr><td><a href="timestamp.html">timestamptz</a> <code>IS NOT DISTINCT FROM</code> <a href="timestamp.html">timestamp</a></td><td><a href="bool.html">bool</a></td></tr> 421 <tr><td><a href="timestamp.html">timestamptz</a> <code>IS NOT DISTINCT FROM</code> <a href="timestamp.html">timestamptz</a></td><td><a href="bool.html">bool</a></td></tr> 422 <tr><td>timestamptz <code>IS NOT DISTINCT FROM</code> timestamptz</td><td><a href="bool.html">bool</a></td></tr> 423 <tr><td>timetz <code>IS NOT DISTINCT FROM</code> <a href="time.html">time</a></td><td><a href="bool.html">bool</a></td></tr> 424 <tr><td>timetz <code>IS NOT DISTINCT FROM</code> timetz</td><td><a href="bool.html">bool</a></td></tr> 425 <tr><td>tuple <code>IS NOT DISTINCT FROM</code> tuple</td><td><a href="bool.html">bool</a></td></tr> 426 <tr><td>unknown <code>IS NOT DISTINCT FROM</code> unknown</td><td><a href="bool.html">bool</a></td></tr> 427 <tr><td><a href="uuid.html">uuid</a> <code>IS NOT DISTINCT FROM</code> <a href="uuid.html">uuid</a></td><td><a href="bool.html">bool</a></td></tr> 428 <tr><td><a href="uuid.html">uuid[]</a> <code>IS NOT DISTINCT FROM</code> <a href="uuid.html">uuid[]</a></td><td><a href="bool.html">bool</a></td></tr> 429 <tr><td>varbit <code>IS NOT DISTINCT FROM</code> varbit</td><td><a href="bool.html">bool</a></td></tr> 430 </tbody></table> 431 <table><thead> 432 <tr><td><code>LIKE</code></td><td>Return</td></tr> 433 </thead><tbody> 434 <tr><td><a href="string.html">string</a> <code>LIKE</code> <a href="string.html">string</a></td><td><a href="bool.html">bool</a></td></tr> 435 </tbody></table> 436 <table><thead> 437 <tr><td><code>SIMILAR TO</code></td><td>Return</td></tr> 438 </thead><tbody> 439 <tr><td><a href="string.html">string</a> <code>SIMILAR TO</code> <a href="string.html">string</a></td><td><a href="bool.html">bool</a></td></tr> 440 </tbody></table> 441 <table><thead> 442 <tr><td><code>^</code></td><td>Return</td></tr> 443 </thead><tbody> 444 <tr><td><a href="decimal.html">decimal</a> <code>^</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 445 <tr><td><a href="decimal.html">decimal</a> <code>^</code> <a href="int.html">int</a></td><td><a href="decimal.html">decimal</a></td></tr> 446 <tr><td><a href="float.html">float</a> <code>^</code> <a href="float.html">float</a></td><td><a href="float.html">float</a></td></tr> 447 <tr><td><a href="int.html">int</a> <code>^</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 448 <tr><td><a href="int.html">int</a> <code>^</code> <a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> 449 </tbody></table> 450 <table><thead> 451 <tr><td><code>|</code></td><td>Return</td></tr> 452 </thead><tbody> 453 <tr><td><a href="inet.html">inet</a> <code>|</code> <a href="inet.html">inet</a></td><td><a href="inet.html">inet</a></td></tr> 454 <tr><td><a href="int.html">int</a> <code>|</code> <a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> 455 <tr><td>varbit <code>|</code> varbit</td><td>varbit</td></tr> 456 </tbody></table> 457 <table><thead> 458 <tr><td><code>|/</code></td><td>Return</td></tr> 459 </thead><tbody> 460 <tr><td><code>|/</code><a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 461 <tr><td><code>|/</code><a href="float.html">float</a></td><td><a href="float.html">float</a></td></tr> 462 </tbody></table> 463 <table><thead> 464 <tr><td><code>||</code></td><td>Return</td></tr> 465 </thead><tbody> 466 <tr><td><a href="bool.html">bool</a> <code>||</code> <a href="bool.html">bool[]</a></td><td><a href="bool.html">bool[]</a></td></tr> 467 <tr><td><a href="bool.html">bool[]</a> <code>||</code> <a href="bool.html">bool</a></td><td><a href="bool.html">bool[]</a></td></tr> 468 <tr><td><a href="bool.html">bool[]</a> <code>||</code> <a href="bool.html">bool[]</a></td><td><a href="bool.html">bool[]</a></td></tr> 469 <tr><td><a href="bytes.html">bytes</a> <code>||</code> <a href="bytes.html">bytes</a></td><td><a href="bytes.html">bytes</a></td></tr> 470 <tr><td><a href="bytes.html">bytes</a> <code>||</code> <a href="bytes.html">bytes[]</a></td><td><a href="bytes.html">bytes[]</a></td></tr> 471 <tr><td><a href="bytes.html">bytes[]</a> <code>||</code> <a href="bytes.html">bytes</a></td><td><a href="bytes.html">bytes[]</a></td></tr> 472 <tr><td><a href="bytes.html">bytes[]</a> <code>||</code> <a href="bytes.html">bytes[]</a></td><td><a href="bytes.html">bytes[]</a></td></tr> 473 <tr><td><a href="date.html">date</a> <code>||</code> <a href="date.html">date[]</a></td><td><a href="date.html">date[]</a></td></tr> 474 <tr><td><a href="date.html">date[]</a> <code>||</code> <a href="date.html">date</a></td><td><a href="date.html">date[]</a></td></tr> 475 <tr><td><a href="date.html">date[]</a> <code>||</code> <a href="date.html">date[]</a></td><td><a href="date.html">date[]</a></td></tr> 476 <tr><td><a href="decimal.html">decimal</a> <code>||</code> <a href="decimal.html">decimal[]</a></td><td><a href="decimal.html">decimal[]</a></td></tr> 477 <tr><td><a href="decimal.html">decimal[]</a> <code>||</code> <a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal[]</a></td></tr> 478 <tr><td><a href="decimal.html">decimal[]</a> <code>||</code> <a href="decimal.html">decimal[]</a></td><td><a href="decimal.html">decimal[]</a></td></tr> 479 <tr><td><a href="float.html">float</a> <code>||</code> <a href="float.html">float[]</a></td><td><a href="float.html">float[]</a></td></tr> 480 <tr><td><a href="float.html">float[]</a> <code>||</code> <a href="float.html">float</a></td><td><a href="float.html">float[]</a></td></tr> 481 <tr><td><a href="float.html">float[]</a> <code>||</code> <a href="float.html">float[]</a></td><td><a href="float.html">float[]</a></td></tr> 482 <tr><td>geography <code>||</code> geography</td><td>geography</td></tr> 483 <tr><td>geometry <code>||</code> geometry</td><td>geometry</td></tr> 484 <tr><td><a href="inet.html">inet</a> <code>||</code> <a href="inet.html">inet[]</a></td><td><a href="inet.html">inet[]</a></td></tr> 485 <tr><td><a href="inet.html">inet[]</a> <code>||</code> <a href="inet.html">inet</a></td><td><a href="inet.html">inet[]</a></td></tr> 486 <tr><td><a href="inet.html">inet[]</a> <code>||</code> <a href="inet.html">inet[]</a></td><td><a href="inet.html">inet[]</a></td></tr> 487 <tr><td><a href="int.html">int</a> <code>||</code> <a href="int.html">int[]</a></td><td><a href="int.html">int[]</a></td></tr> 488 <tr><td><a href="int.html">int[]</a> <code>||</code> <a href="int.html">int</a></td><td><a href="int.html">int[]</a></td></tr> 489 <tr><td><a href="int.html">int[]</a> <code>||</code> <a href="int.html">int[]</a></td><td><a href="int.html">int[]</a></td></tr> 490 <tr><td><a href="interval.html">interval</a> <code>||</code> <a href="interval.html">interval[]</a></td><td><a href="interval.html">interval[]</a></td></tr> 491 <tr><td><a href="interval.html">interval[]</a> <code>||</code> <a href="interval.html">interval</a></td><td><a href="interval.html">interval[]</a></td></tr> 492 <tr><td><a href="interval.html">interval[]</a> <code>||</code> <a href="interval.html">interval[]</a></td><td><a href="interval.html">interval[]</a></td></tr> 493 <tr><td>jsonb <code>||</code> jsonb</td><td>jsonb</td></tr> 494 <tr><td>oid <code>||</code> oid</td><td>oid</td></tr> 495 <tr><td><a href="string.html">string</a> <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> 496 <tr><td><a href="string.html">string</a> <code>||</code> <a href="string.html">string[]</a></td><td><a href="string.html">string[]</a></td></tr> 497 <tr><td><a href="string.html">string[]</a> <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string[]</a></td></tr> 498 <tr><td><a href="string.html">string[]</a> <code>||</code> <a href="string.html">string[]</a></td><td><a href="string.html">string[]</a></td></tr> 499 <tr><td><a href="time.html">time</a> <code>||</code> <a href="time.html">time[]</a></td><td><a href="time.html">time[]</a></td></tr> 500 <tr><td><a href="time.html">time[]</a> <code>||</code> <a href="time.html">time</a></td><td><a href="time.html">time[]</a></td></tr> 501 <tr><td><a href="time.html">time[]</a> <code>||</code> <a href="time.html">time[]</a></td><td><a href="time.html">time[]</a></td></tr> 502 <tr><td><a href="timestamp.html">timestamp</a> <code>||</code> <a href="timestamp.html">timestamp[]</a></td><td><a href="timestamp.html">timestamp[]</a></td></tr> 503 <tr><td><a href="timestamp.html">timestamp[]</a> <code>||</code> <a href="timestamp.html">timestamp</a></td><td><a href="timestamp.html">timestamp[]</a></td></tr> 504 <tr><td><a href="timestamp.html">timestamp[]</a> <code>||</code> <a href="timestamp.html">timestamp[]</a></td><td><a href="timestamp.html">timestamp[]</a></td></tr> 505 <tr><td><a href="timestamp.html">timestamptz</a> <code>||</code> timestamptz</td><td>timestamptz</td></tr> 506 <tr><td>timestamptz <code>||</code> <a href="timestamp.html">timestamptz</a></td><td>timestamptz</td></tr> 507 <tr><td>timestamptz <code>||</code> timestamptz</td><td>timestamptz</td></tr> 508 <tr><td>timetz <code>||</code> timetz</td><td>timetz</td></tr> 509 <tr><td><a href="uuid.html">uuid</a> <code>||</code> <a href="uuid.html">uuid[]</a></td><td><a href="uuid.html">uuid[]</a></td></tr> 510 <tr><td><a href="uuid.html">uuid[]</a> <code>||</code> <a href="uuid.html">uuid</a></td><td><a href="uuid.html">uuid[]</a></td></tr> 511 <tr><td><a href="uuid.html">uuid[]</a> <code>||</code> <a href="uuid.html">uuid[]</a></td><td><a href="uuid.html">uuid[]</a></td></tr> 512 <tr><td>varbit <code>||</code> varbit</td><td>varbit</td></tr> 513 </tbody></table> 514 <table><thead> 515 <tr><td><code>||/</code></td><td>Return</td></tr> 516 </thead><tbody> 517 <tr><td><code>||/</code><a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> 518 <tr><td><code>||/</code><a href="float.html">float</a></td><td><a href="float.html">float</a></td></tr> 519 </tbody></table> 520 <table><thead> 521 <tr><td><code>~</code></td><td>Return</td></tr> 522 </thead><tbody> 523 <tr><td><code>~</code><a href="inet.html">inet</a></td><td><a href="inet.html">inet</a></td></tr> 524 <tr><td><code>~</code><a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> 525 <tr><td><code>~</code>varbit</td><td>varbit</td></tr> 526 <tr><td><a href="string.html">string</a> <code>~</code> <a href="string.html">string</a></td><td><a href="bool.html">bool</a></td></tr> 527 </tbody></table> 528 <table><thead> 529 <tr><td><code>~*</code></td><td>Return</td></tr> 530 </thead><tbody> 531 <tr><td><a href="string.html">string</a> <code>~*</code> <a href="string.html">string</a></td><td><a href="bool.html">bool</a></td></tr> 532 </tbody></table>