Back to Cockroach

Operators

docs/generated/sql/operators.md

26.1.365.5 KB
Original Source
<table><thead> <tr><td><code>#</code></td><td>Return</td></tr> </thead><tbody> <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> <tr><td>varbit <code>#</code> varbit</td><td>varbit</td></tr> </tbody></table> <table><thead> <tr><td><code>#></code></td><td>Return</td></tr> </thead><tbody> <tr><td>jsonb <code>#></code> <a href="string.html">string[]</a></td><td>jsonb</td></tr> </tbody></table> <table><thead> <tr><td><code>#>></code></td><td>Return</td></tr> </thead><tbody> <tr><td>jsonb <code>#>></code> <a href="string.html">string[]</a></td><td><a href="string.html">string</a></td></tr> </tbody></table> <table><thead> <tr><td><code>%</code></td><td>Return</td></tr> </thead><tbody> <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> <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> <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> <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> <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> <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> </tbody></table> <table><thead> <tr><td><code>&</code></td><td>Return</td></tr> </thead><tbody> <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> <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> <tr><td>varbit <code>&</code> varbit</td><td>varbit</td></tr> </tbody></table> <table><thead> <tr><td><code>&&</code></td><td>Return</td></tr> </thead><tbody> <tr><td>anyelement <code>&&</code> anyelement</td><td><a href="bool.html">bool</a></td></tr> <tr><td>box2d <code>&&</code> box2d</td><td><a href="bool.html">bool</a></td></tr> <tr><td>box2d <code>&&</code> geometry</td><td><a href="bool.html">bool</a></td></tr> <tr><td>geometry <code>&&</code> box2d</td><td><a href="bool.html">bool</a></td></tr> <tr><td>geometry <code>&&</code> geometry</td><td><a href="bool.html">bool</a></td></tr> <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> </tbody></table> <table><thead> <tr><td><code>*</code></td><td>Return</td></tr> </thead><tbody> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <tr><td>vector <code>*</code> vector</td><td>vector</td></tr> </tbody></table> <table><thead> <tr><td><code>+</code></td><td>Return</td></tr> </thead><tbody> <tr><td><code>+</code><a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> <tr><td><code>+</code><a href="float.html">float</a></td><td><a href="float.html">float</a></td></tr> <tr><td><code>+</code><a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> <tr><td><code>+</code><a href="interval.html">interval</a></td><td><a href="interval.html">interval</a></td></tr> <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> <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> <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> <tr><td><a href="date.html">date</a> <code>+</code> timetz</td><td><a href="timestamp.html">timestamptz</a></td></tr> <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> <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> <tr><td><a href="decimal.html">decimal</a> <code>+</code> pg_lsn</td><td>pg_lsn</td></tr> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <tr><td><a href="interval.html">interval</a> <code>+</code> timetz</td><td>timetz</td></tr> <tr><td>pg_lsn <code>+</code> <a href="decimal.html">decimal</a></td><td>pg_lsn</td></tr> <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> <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> <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> <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> <tr><td>timetz <code>+</code> <a href="date.html">date</a></td><td><a href="timestamp.html">timestamptz</a></td></tr> <tr><td>timetz <code>+</code> <a href="interval.html">interval</a></td><td>timetz</td></tr> <tr><td>vector <code>+</code> vector</td><td>vector</td></tr> </tbody></table> <table><thead> <tr><td><code>-</code></td><td>Return</td></tr> </thead><tbody> <tr><td><code>-</code><a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> <tr><td><code>-</code><a href="float.html">float</a></td><td><a href="float.html">float</a></td></tr> <tr><td><code>-</code><a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> <tr><td><code>-</code><a href="interval.html">interval</a></td><td><a href="interval.html">interval</a></td></tr> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <tr><td>jsonb <code>-</code> <a href="int.html">int</a></td><td>jsonb</td></tr> <tr><td>jsonb <code>-</code> <a href="string.html">string</a></td><td>jsonb</td></tr> <tr><td>jsonb <code>-</code> <a href="string.html">string[]</a></td><td>jsonb</td></tr> <tr><td>pg_lsn <code>-</code> <a href="decimal.html">decimal</a></td><td>pg_lsn</td></tr> <tr><td>pg_lsn <code>-</code> pg_lsn</td><td><a href="decimal.html">decimal</a></td></tr> <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> <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> <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> <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> <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> <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> <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> <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> <tr><td>timetz <code>-</code> <a href="interval.html">interval</a></td><td>timetz</td></tr> <tr><td>vector <code>-</code> vector</td><td>vector</td></tr> </tbody></table> <table><thead> <tr><td><code>-></code></td><td>Return</td></tr> </thead><tbody> <tr><td>jsonb <code>-></code> <a href="int.html">int</a></td><td>jsonb</td></tr> <tr><td>jsonb <code>-></code> <a href="string.html">string</a></td><td>jsonb</td></tr> </tbody></table> <table><thead> <tr><td><code>->></code></td><td>Return</td></tr> </thead><tbody> <tr><td>jsonb <code>->></code> <a href="int.html">int</a></td><td><a href="string.html">string</a></td></tr> <tr><td>jsonb <code>->></code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> </tbody></table> <table><thead> <tr><td><code>/</code></td><td>Return</td></tr> </thead><tbody> <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> <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> <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> <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> <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> <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> <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> </tbody></table> <table><thead> <tr><td><code>//</code></td><td>Return</td></tr> </thead><tbody> <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> <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> <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> <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> <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> </tbody></table> <table><thead> <tr><td><code><</code></td><td>Return</td></tr> </thead><tbody> <tr><td>anyenum <code><</code> anyenum</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <tr><td>box2d <code><</code> box2d</td><td><a href="bool.html">bool</a></td></tr> <tr><td>bpchar <code><</code> bpchar</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <tr><td><a href="collate.html">collatedstring</a> <code><</code> <a href="collate.html">collatedstring</a></td><td><a href="bool.html">bool</a></td></tr> <tr><td>collatedstring{*} <code><</code> collatedstring{*}</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <tr><td>geography <code><</code> geography</td><td><a href="bool.html">bool</a></td></tr> <tr><td>geometry <code><</code> geometry</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <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> <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> <tr><td><a href="int.html">int</a> <code><</code> oid</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <tr><td>jsonb <code><</code> jsonb</td><td><a href="bool.html">bool</a></td></tr> <tr><td>ltree <code><</code> ltree</td><td><a href="bool.html">bool</a></td></tr> <tr><td>oid <code><</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> <tr><td>oid <code><</code> oid</td><td><a href="bool.html">bool</a></td></tr> <tr><td>pg_lsn <code><</code> pg_lsn</td><td><a href="bool.html">bool</a></td></tr> <tr><td>refcursor <code><</code> refcursor</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <tr><td><a href="time.html">time</a> <code><</code> timetz</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <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> <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> <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> <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> <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> <tr><td>timestamptz <code><</code> timestamptz</td><td><a href="bool.html">bool</a></td></tr> <tr><td>timetz <code><</code> <a href="time.html">time</a></td><td><a href="bool.html">bool</a></td></tr> <tr><td>timetz <code><</code> timetz</td><td><a href="bool.html">bool</a></td></tr> <tr><td>tuple <code><</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <tr><td>varbit <code><</code> varbit</td><td><a href="bool.html">bool</a></td></tr> <tr><td>vector <code><</code> vector</td><td><a href="bool.html">bool</a></td></tr> </tbody></table> <table><thead> <tr><td><code><#></code></td><td>Return</td></tr> </thead><tbody> <tr><td>vector <code><#></code> vector</td><td><a href="float.html">float</a></td></tr> </tbody></table> <table><thead> <tr><td><code><-></code></td><td>Return</td></tr> </thead><tbody> <tr><td>vector <code><-></code> vector</td><td><a href="float.html">float</a></td></tr> </tbody></table> <table><thead> <tr><td><code><<</code></td><td>Return</td></tr> </thead><tbody> <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> <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> <tr><td>varbit <code><<</code> <a href="int.html">int</a></td><td>varbit</td></tr> </tbody></table> <table><thead> <tr><td><code><=</code></td><td>Return</td></tr> </thead><tbody> <tr><td>anyenum <code><=</code> anyenum</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <tr><td>box2d <code><=</code> box2d</td><td><a href="bool.html">bool</a></td></tr> <tr><td>bpchar <code><=</code> bpchar</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <tr><td><a href="collate.html">collatedstring</a> <code><=</code> <a href="collate.html">collatedstring</a></td><td><a href="bool.html">bool</a></td></tr> <tr><td>collatedstring{*} <code><=</code> collatedstring{*}</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <tr><td>geography <code><=</code> geography</td><td><a href="bool.html">bool</a></td></tr> <tr><td>geometry <code><=</code> geometry</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <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> <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> <tr><td><a href="int.html">int</a> <code><=</code> oid</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <tr><td>jsonb <code><=</code> jsonb</td><td><a href="bool.html">bool</a></td></tr> <tr><td>ltree <code><=</code> ltree</td><td><a href="bool.html">bool</a></td></tr> <tr><td>oid <code><=</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> <tr><td>oid <code><=</code> oid</td><td><a href="bool.html">bool</a></td></tr> <tr><td>pg_lsn <code><=</code> pg_lsn</td><td><a href="bool.html">bool</a></td></tr> <tr><td>refcursor <code><=</code> refcursor</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <tr><td><a href="time.html">time</a> <code><=</code> timetz</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <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> <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> <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> <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> <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> <tr><td>timestamptz <code><=</code> timestamptz</td><td><a href="bool.html">bool</a></td></tr> <tr><td>timetz <code><=</code> <a href="time.html">time</a></td><td><a href="bool.html">bool</a></td></tr> <tr><td>timetz <code><=</code> timetz</td><td><a href="bool.html">bool</a></td></tr> <tr><td>tuple <code><=</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <tr><td>varbit <code><=</code> varbit</td><td><a href="bool.html">bool</a></td></tr> <tr><td>vector <code><=</code> vector</td><td><a href="bool.html">bool</a></td></tr> </tbody></table> <table><thead> <tr><td><code><=></code></td><td>Return</td></tr> </thead><tbody> <tr><td>vector <code><=></code> vector</td><td><a href="float.html">float</a></td></tr> </tbody></table> <table><thead> <tr><td><code><@</code></td><td>Return</td></tr> </thead><tbody> <tr><td>anyelement <code><@</code> anyelement</td><td><a href="bool.html">bool</a></td></tr> <tr><td>jsonb <code><@</code> jsonb</td><td><a href="bool.html">bool</a></td></tr> <tr><td>ltree <code><@</code> ltree</td><td><a href="bool.html">bool</a></td></tr> </tbody></table> <table><thead> <tr><td><code>=</code></td><td>Return</td></tr> </thead><tbody> <tr><td>anyenum <code>=</code> anyenum</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <tr><td>box2d <code>=</code> box2d</td><td><a href="bool.html">bool</a></td></tr> <tr><td>bpchar <code>=</code> bpchar</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <tr><td><a href="collate.html">collatedstring</a> <code>=</code> <a href="collate.html">collatedstring</a></td><td><a href="bool.html">bool</a></td></tr> <tr><td>collatedstring{*} <code>=</code> collatedstring{*}</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <tr><td>geography <code>=</code> geography</td><td><a href="bool.html">bool</a></td></tr> <tr><td>geometry <code>=</code> geometry</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <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> <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> <tr><td><a href="int.html">int</a> <code>=</code> oid</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <tr><td>jsonb <code>=</code> jsonb</td><td><a href="bool.html">bool</a></td></tr> <tr><td>ltree <code>=</code> ltree</td><td><a href="bool.html">bool</a></td></tr> <tr><td>oid <code>=</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> <tr><td>oid <code>=</code> oid</td><td><a href="bool.html">bool</a></td></tr> <tr><td>pg_lsn <code>=</code> pg_lsn</td><td><a href="bool.html">bool</a></td></tr> <tr><td>refcursor <code>=</code> refcursor</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <tr><td><a href="time.html">time</a> <code>=</code> timetz</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <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> <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> <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> <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> <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> <tr><td>timestamptz <code>=</code> timestamptz</td><td><a href="bool.html">bool</a></td></tr> <tr><td>timetz <code>=</code> <a href="time.html">time</a></td><td><a href="bool.html">bool</a></td></tr> <tr><td>timetz <code>=</code> timetz</td><td><a href="bool.html">bool</a></td></tr> <tr><td>tsquery <code>=</code> tsquery</td><td><a href="bool.html">bool</a></td></tr> <tr><td>tsvector <code>=</code> tsvector</td><td><a href="bool.html">bool</a></td></tr> <tr><td>tuple <code>=</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <tr><td>varbit <code>=</code> varbit</td><td><a href="bool.html">bool</a></td></tr> <tr><td>vector <code>=</code> vector</td><td><a href="bool.html">bool</a></td></tr> </tbody></table> <table><thead> <tr><td><code>>></code></td><td>Return</td></tr> </thead><tbody> <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> <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> <tr><td>varbit <code>>></code> <a href="int.html">int</a></td><td>varbit</td></tr> </tbody></table> <table><thead> <tr><td><code>?</code></td><td>Return</td></tr> </thead><tbody> <tr><td>jsonb <code>?</code> <a href="string.html">string</a></td><td><a href="bool.html">bool</a></td></tr> </tbody></table> <table><thead> <tr><td><code>?&</code></td><td>Return</td></tr> </thead><tbody> <tr><td>jsonb <code>?&</code> <a href="string.html">string[]</a></td><td><a href="bool.html">bool</a></td></tr> </tbody></table> <table><thead> <tr><td><code>?<@</code></td><td>Return</td></tr> </thead><tbody> <tr><td>ltree <code>?<@</code> ltree</td><td>ltree</td></tr> </tbody></table> <table><thead> <tr><td><code>?@></code></td><td>Return</td></tr> </thead><tbody> <tr><td>ltree <code>?@></code> ltree</td><td>ltree</td></tr> </tbody></table> <table><thead> <tr><td><code>?|</code></td><td>Return</td></tr> </thead><tbody> <tr><td>jsonb <code>?|</code> <a href="string.html">string[]</a></td><td><a href="bool.html">bool</a></td></tr> </tbody></table> <table><thead> <tr><td><code>@></code></td><td>Return</td></tr> </thead><tbody> <tr><td>anyelement <code>@></code> anyelement</td><td><a href="bool.html">bool</a></td></tr> <tr><td>jsonb <code>@></code> jsonb</td><td><a href="bool.html">bool</a></td></tr> <tr><td>ltree <code>@></code> ltree</td><td><a href="bool.html">bool</a></td></tr> </tbody></table> <table><thead> <tr><td><code>@@</code></td><td>Return</td></tr> </thead><tbody> <tr><td>tsquery <code>@@</code> tsvector</td><td><a href="bool.html">bool</a></td></tr> <tr><td>tsvector <code>@@</code> tsquery</td><td><a href="bool.html">bool</a></td></tr> </tbody></table> <table><thead> <tr><td><code>ILIKE</code></td><td>Return</td></tr> </thead><tbody> <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> </tbody></table> <table><thead> <tr><td><code>IN</code></td><td>Return</td></tr> </thead><tbody> <tr><td>anyenum <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td><a href="bool.html">bool</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td>box2d <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td>bpchar <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td><a href="bytes.html">bytes</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td><a href="collate.html">collatedstring</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td><a href="date.html">date</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td><a href="decimal.html">decimal</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td><a href="float.html">float</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td>geography <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td>geometry <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td><a href="inet.html">inet</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td><a href="int.html">int</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td><a href="interval.html">interval</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td>jsonb <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td>ltree <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td>oid <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td>pg_lsn <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td>refcursor <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td><a href="string.html">string</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td><a href="time.html">time</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td><a href="timestamp.html">timestamp</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td><a href="timestamp.html">timestamptz</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td>timetz <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td>tuple <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td><a href="uuid.html">uuid</a> <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td>varbit <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td>vector <code>IN</code> tuple</td><td><a href="bool.html">bool</a></td></tr> </tbody></table> <table><thead> <tr><td><code>IS NOT DISTINCT FROM</code></td><td>Return</td></tr> </thead><tbody> <tr><td>anyelement <code>IS NOT DISTINCT FROM</code> unknown</td><td><a href="bool.html">bool</a></td></tr> <tr><td>anyenum <code>IS NOT DISTINCT FROM</code> anyenum</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <tr><td>box2d <code>IS NOT DISTINCT FROM</code> box2d</td><td><a href="bool.html">bool</a></td></tr> <tr><td>bpchar <code>IS NOT DISTINCT FROM</code> bpchar</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <tr><td><a href="collate.html">collatedstring</a> <code>IS NOT DISTINCT FROM</code> <a href="collate.html">collatedstring</a></td><td><a href="bool.html">bool</a></td></tr> <tr><td>collatedstring{*} <code>IS NOT DISTINCT FROM</code> collatedstring{*}</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <tr><td>geography <code>IS NOT DISTINCT FROM</code> geography</td><td><a href="bool.html">bool</a></td></tr> <tr><td>geometry <code>IS NOT DISTINCT FROM</code> geometry</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <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> <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> <tr><td><a href="int.html">int</a> <code>IS NOT DISTINCT FROM</code> oid</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <tr><td>jsonb <code>IS NOT DISTINCT FROM</code> jsonb</td><td><a href="bool.html">bool</a></td></tr> <tr><td>jsonpath <code>IS NOT DISTINCT FROM</code> jsonpath</td><td><a href="bool.html">bool</a></td></tr> <tr><td>ltree <code>IS NOT DISTINCT FROM</code> ltree</td><td><a href="bool.html">bool</a></td></tr> <tr><td>oid <code>IS NOT DISTINCT FROM</code> <a href="int.html">int</a></td><td><a href="bool.html">bool</a></td></tr> <tr><td>oid <code>IS NOT DISTINCT FROM</code> oid</td><td><a href="bool.html">bool</a></td></tr> <tr><td>pg_lsn <code>IS NOT DISTINCT FROM</code> pg_lsn</td><td><a href="bool.html">bool</a></td></tr> <tr><td>refcursor <code>IS NOT DISTINCT FROM</code> refcursor</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <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> <tr><td>timestamptz <code>IS NOT DISTINCT FROM</code> timestamptz</td><td><a href="bool.html">bool</a></td></tr> <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> <tr><td>timetz <code>IS NOT DISTINCT FROM</code> timetz</td><td><a href="bool.html">bool</a></td></tr> <tr><td>tsquery <code>IS NOT DISTINCT FROM</code> tsquery</td><td><a href="bool.html">bool</a></td></tr> <tr><td>tsvector <code>IS NOT DISTINCT FROM</code> tsvector</td><td><a href="bool.html">bool</a></td></tr> <tr><td>tuple <code>IS NOT DISTINCT FROM</code> tuple</td><td><a href="bool.html">bool</a></td></tr> <tr><td>unknown <code>IS NOT DISTINCT FROM</code> unknown</td><td><a href="bool.html">bool</a></td></tr> <tr><td>unknown <code>IS NOT DISTINCT FROM</code> void</td><td><a href="bool.html">bool</a></td></tr> <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> <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> <tr><td>varbit <code>IS NOT DISTINCT FROM</code> varbit</td><td><a href="bool.html">bool</a></td></tr> <tr><td>vector <code>IS NOT DISTINCT FROM</code> vector</td><td><a href="bool.html">bool</a></td></tr> <tr><td>void <code>IS NOT DISTINCT FROM</code> unknown</td><td><a href="bool.html">bool</a></td></tr> </tbody></table> <table><thead> <tr><td><code>LIKE</code></td><td>Return</td></tr> </thead><tbody> <tr><td><a href="collate.html">collatedstring</a> <code>LIKE</code> <a href="collate.html">collatedstring</a></td><td><a href="bool.html">bool</a></td></tr> <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> </tbody></table> <table><thead> <tr><td><code>SIMILAR TO</code></td><td>Return</td></tr> </thead><tbody> <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> </tbody></table> <table><thead> <tr><td><code>^</code></td><td>Return</td></tr> </thead><tbody> <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> <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> <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> <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> <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> </tbody></table> <table><thead> <tr><td><code>|</code></td><td>Return</td></tr> </thead><tbody> <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> <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> <tr><td>varbit <code>|</code> varbit</td><td>varbit</td></tr> </tbody></table> <table><thead> <tr><td><code>|/</code></td><td>Return</td></tr> </thead><tbody> <tr><td><code>|/</code><a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> <tr><td><code>|/</code><a href="float.html">float</a></td><td><a href="float.html">float</a></td></tr> </tbody></table> <table><thead> <tr><td><code>||</code></td><td>Return</td></tr> </thead><tbody> <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> <tr><td><a href="bool.html">bool</a> <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <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> <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> <tr><td>box2d <code>||</code> box2d</td><td>box2d</td></tr> <tr><td>box2d <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <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> <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> <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> <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> <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> <tr><td><a href="date.html">date</a> <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <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> <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> <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> <tr><td><a href="decimal.html">decimal</a> <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <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> <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> <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> <tr><td><a href="float.html">float</a> <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <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> <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> <tr><td>geography <code>||</code> geography</td><td>geography</td></tr> <tr><td>geography <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <tr><td>geometry <code>||</code> geometry</td><td>geometry</td></tr> <tr><td>geometry <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <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> <tr><td><a href="inet.html">inet</a> <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <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> <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> <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> <tr><td><a href="int.html">int</a> <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <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> <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> <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> <tr><td><a href="interval.html">interval</a> <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <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> <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> <tr><td>jsonb <code>||</code> jsonb</td><td>jsonb</td></tr> <tr><td>jsonb <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <tr><td>ltree <code>||</code> ltree</td><td>ltree</td></tr> <tr><td>ltree <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <tr><td>oid <code>||</code> oid</td><td>oid</td></tr> <tr><td>oid <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <tr><td>pg_lsn <code>||</code> pg_lsn</td><td>pg_lsn</td></tr> <tr><td>pg_lsn <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <tr><td>refcursor <code>||</code> refcursor</td><td>refcursor</td></tr> <tr><td>refcursor <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> <a href="bool.html">bool</a></td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> box2d</td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> <a href="date.html">date</a></td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> <a href="decimal.html">decimal</a></td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> <a href="float.html">float</a></td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> geography</td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> geometry</td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> <a href="inet.html">inet</a></td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> <a href="int.html">int</a></td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> <a href="interval.html">interval</a></td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> jsonb</td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> ltree</td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> oid</td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> pg_lsn</td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> refcursor</td><td><a href="string.html">string</a></td></tr> <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> <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> <tr><td><a href="string.html">string</a> <code>||</code> <a href="time.html">time</a></td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> <a href="timestamp.html">timestamp</a></td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> <a href="timestamp.html">timestamptz</a></td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> timetz</td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> tuple</td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> <a href="uuid.html">uuid</a></td><td><a href="string.html">string</a></td></tr> <tr><td><a href="string.html">string</a> <code>||</code> varbit</td><td><a href="string.html">string</a></td></tr> <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> <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> <tr><td><a href="time.html">time</a> <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <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> <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> <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> <tr><td><a href="timestamp.html">timestamp</a> <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <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> <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> <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> <tr><td><a href="timestamp.html">timestamptz</a> <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <tr><td><a href="timestamp.html">timestamptz</a> <code>||</code> timestamptz</td><td>timestamptz</td></tr> <tr><td>timestamptz <code>||</code> <a href="timestamp.html">timestamptz</a></td><td>timestamptz</td></tr> <tr><td>timestamptz <code>||</code> timestamptz</td><td>timestamptz</td></tr> <tr><td>timetz <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <tr><td>timetz <code>||</code> timetz</td><td>timetz</td></tr> <tr><td>tuple <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <tr><td><a href="uuid.html">uuid</a> <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <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> <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> <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> <tr><td>varbit <code>||</code> <a href="string.html">string</a></td><td><a href="string.html">string</a></td></tr> <tr><td>varbit <code>||</code> varbit</td><td>varbit</td></tr> </tbody></table> <table><thead> <tr><td><code>||/</code></td><td>Return</td></tr> </thead><tbody> <tr><td><code>||/</code><a href="decimal.html">decimal</a></td><td><a href="decimal.html">decimal</a></td></tr> <tr><td><code>||/</code><a href="float.html">float</a></td><td><a href="float.html">float</a></td></tr> </tbody></table> <table><thead> <tr><td><code>~</code></td><td>Return</td></tr> </thead><tbody> <tr><td><code>~</code><a href="inet.html">inet</a></td><td><a href="inet.html">inet</a></td></tr> <tr><td><code>~</code><a href="int.html">int</a></td><td><a href="int.html">int</a></td></tr> <tr><td><code>~</code>varbit</td><td>varbit</td></tr> <tr><td>box2d <code>~</code> box2d</td><td><a href="bool.html">bool</a></td></tr> <tr><td>box2d <code>~</code> geometry</td><td><a href="bool.html">bool</a></td></tr> <tr><td>geometry <code>~</code> box2d</td><td><a href="bool.html">bool</a></td></tr> <tr><td>geometry <code>~</code> geometry</td><td><a href="bool.html">bool</a></td></tr> <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> </tbody></table> <table><thead> <tr><td><code>~*</code></td><td>Return</td></tr> </thead><tbody> <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> </tbody></table>