Relational Operators

Operators are symbols or keywords used to perform specific operations.

Order of Precedence

This table lists all KWDB operators from highest to lowest precedence, which determines the order in which they are evaluated within a statement. Operators with the same precedence are left associative. This means that those operators are grouped together starting from the left and moving right.

Order of Precedence	Operator	Name	Operator Arity
1	.	Member field access operator	binary
2	::	Type cast	binary
3	-	Unary minus	unary (prefix)
3	~	Bitwise not	unary (prefix)
4	^	Exponentiation	binary
5	*	Multiplication	binary
5	/	Division	binary
5	//	Floor division	binary
5	%	Modulo	binary
6	+	Addition	binary
6	-	Subtraction	binary
7	<<	Bitwise left-shift	binary
7	>>	Bitwise right-shift	binary
8	&	Bitwise AND	binary
9	#	Bitwise XOR	binary
10	|	Bitwise OR	binary
11	||	Concatenation	binary
11	< ANY, SOME, ALL	Multi-valued "less than" comparison	binary
11	> ANY, SOME, ALL	Multi-valued "greater than" comparison	binary
11	= ANY, SOME, ALL	Multi-valued "equal" comparison	binary
11	<= ANY, SOME, ALL	Multi-valued "less than or equal" comparison	binary
11	>= ANY, SOME, ALL	Multi-valued "greater than or equal" comparison	binary
11	<> ANY / != ANY, <> SOME / != SOME, <> ALL / != ALL	Multi-valued "not equal" comparison	binary
11	[NOT] LIKE ANY, [NOT] LIKE SOME, [NOT] LIKE ALL	Multi-valued LIKE comparison	binary
11	[NOT] ILIKE ANY, [NOT] ILIKE SOME, [NOT] ILIKE ALL	Multi-valued LIKE comparison	binary
12	[NOT] BETWEEN	Value is [not] within the range specified	binary
	[NOT] BETWEEN SYMMETRIC	Like [NOT] BETWEEN, but in non-sorted order. For example, whereas a BETWEEN b AND c means b <= a <= c, a BETWEEN SYMMETRIC b AND c means (b <= a <= c) OR (c <= a <= b).	binary
12	[NOT] IN	Value is [not] in the set of values specified	binary
12	[NOT] LIKE	Matches [or not] LIKE expression, case sensitive	binary
12	[NOT] ILIKE	Matches [or not] LIKE expression, case insensitive	binary
12	[NOT] SIMILAR	Matches [or not] SIMILAR TO regular expression	binary
12	~	Matches regular expression, case sensitive	binary
12	!~	Does not match regular expression, case sensitive	binary
12	~*	Matches regular expression, case insensitive	binary
12	!~*	Does not match regular expression, case insensitive	binary
13	=	Equal	binary
13	<	Less than	binary
13	>	Greater than	binary
13	<=	Less than or equal to	binary
13	>=	Greater than or equal to	binary
13	!=, <>	Not equal	binary
14	IS [DISTINCT FROM]	Equal, considering NULL as value值	binary
14	IS NOT [DISTINCT FROM]	Not equal, a IS NOT b equivalent to NOT (a IS b)	binary
14	ISNULL, IS UNKNOWN, NOTNULL, IS NOT UNKNOWN	Equivalent to IS NULL / IS NOT NULL	unary (suffix)
14	IS NAN, IS NOT NAN	Comparison with the floating-point NaN value	unary (suffix)
14	IS OF(...)	Type predicate	unary (suffix)
15	NOT	Logical NOT	unary
16	AND	Logical AND	binary
17	OR	Logical OR	binary

Supported Operators

Operator	Expression	Return
#	int2 # int2	int8
#	int2 # int4	int8
#	int2 # int8	int8
#	int4 # int2	int8
#	int4 # int4	int8
#	int4 # int8	int8
#	int8 # int2	int8
#	int8 # int4	int8
#	int8 # int8	int8
#	varbit # varbit	varbit
#>	jsonb #> STRING[]	jsonb
#>>	jsonb #>> STRING[]	STRING
%	decimal % decimal	decimal
%	decimal % INT2	decimal
%	decimal % INT4	decimal
%	decimal % INT8	decimal
%	float4 % float4	float8
%	float4 % float8	float8
%	float8 % float4	float8
%	float8 % float8	float8
%	INT2 % decimal	decimal
%	INT4 % decimal	decimal
%	INT8 % decimal	decimal
%	int2 % int2	int8
%	int2 % int4	int8
%	int2 % int8	int8
%	int4 % int2	int8
%	int4 % int4	int8
%	int4 % int8	int8
%	int8 % int2	int8
%	int8 % int4	int8
%	int8 % int8	int8
&	INET & INET	INET
&	int2 & int2	int8
&	int2 & int4	int8
&	int2 & int8	int8
&	int4 & int2	int8
&	int4 & int4	int8
&	int4 & int8	int8
&	int8 & int2	int8
&	int8 & int4	int8
&	int8 & int8	int8
&	varbit & varbit	varbit
&&	anyelement && anyelement	BOOL
&&	INET && INET	BOOL
*	decimal * decimal	decimal
*	decimal * INT2	decimal
*	decimal * INT4	decimal
*	decimal * INT8	decimal
*	decimal * interval	interval
*	float4 * float4	float8
*	float4 * float8	float8
*	float8 * float4	float8
*	float8 * float8	float8
*	FLOAT4 * interval	interval
*	FLOAT8 * interval	interval
*	INT2 * decimal	decimal
*	INT4 * decimal	decimal
*	INT8 * decimal	decimal
*	int2 * int2	int8
*	int2 * int4	int8
*	int2 * int8	int8
*	int4 * int2	int8
*	int4 * int4	int8
*	int4 * int8	int8
*	int8 * int2	int8
*	int8 * int4	int8
*	int8 * int8	int8
*	INT2 * interval	interval
*	INT4 * interval	interval
*	INT8 * interval	interval
*	interval * decimal	interval
*	interval * FLOAT4	interval
*	interval * FLOAT8	interval
*	interval * INT2	interval
*	interval * INT4	interval
*	interval * INT8	interval
+	date + INT2	date
+	date + INT4	date
+	date + INT8	date
+	date + interval	timestamptz
+	date + time	timestamp
+	decimal + decimal	decimal
+	decimal + INT2	decimal
+	decimal + INT4	decimal
+	decimal + INT8	decimal
+	float4 + float4	float8
+	float4 + float8	float8
+	float8 + float4	float8
+	float8 + float8	float8
+	INET + INT2	INET
+	INET + INT4	INET
+	INET + INT8	INET
+	INT2 + date	date
+	INT4 + date	date
+	INT8 + date	date
+	INT2 + decimal	decimal
+	INT4 + decimal	decimal
+	INT8 + decimal	decimal
+	INT2 + INET	INET
+	INT4 + INET	INET
+	INT8 + INET	INET
+	int2 + int2	int8
+	int2 + int4	int8
+	int2 + int8	int8
+	int4 + int2	int8
+	int4 + int4	int8
+	int4 + int8	int8
+	int8 + int2	int8
+	int8 + int4	int8
+	int8 + int8	int8
+	interval + date	timestamptz
+	interval + interval	interval
+	interval + time	time
+	interval + timestamp	timestamp
+	interval + timestamptz	timestamptz
+	time + date	timestamp
+	time + interval	time
+	timestamp + interval	timestamp
+	timestamptz + interval	timestamptz
+	timetz + date	timestamptz
+	timetz + interval	timetz
-	-decimal	decimal
-	-float4	float8
-	-float8	float8
-	-int2	int8
-	-int4	int8
-	-int8	int8
-	-interval	interval
-	date - date	INT8
-	date - INT2	date
-	date - INT4	date
-	date - INT8	date
-	date - interval	timestamptz
-	date - time	timestamp
-	decimal - decimal	decimal
-	decimal - INT2	decimal
-	decimal - INT4	decimal
-	decimal - INT8	decimal
-	float4 - float4	float8
-	float4 - float8	float8
-	float8 - float4	float8
-	float8 - float8	float8
-	INET - INET	INT8
-	INET - INT2	INET
-	INET - INT4	INET
-	INET - INT8	INET
-	INT2 - decimal	decimal
-	INT4 - decimal	decimal
-	INT8 - decimal	decimal
-	int2 - int2	int8
-	int2 - int4	int8
-	int2 - int8	int8
-	int4 - int2	int8
-	int4 - int4	int8
-	int4 - int8	int8
-	int8 - int2	int8
-	int8 - int4	int8
	int8 - int8	int8
-	interval - interval	interval
-	jsonb - INT2	jsonb
-	jsonb - INT4	jsonb
-	jsonb - INT8	jsonb
-	jsonb - STRING	jsonb
-	jsonb - STRING[]	jsonb
-	time - interval	time
-	time - time	interval
-	timestamp - interval	timestamp
-	timestamp - timestamp	interval
-	timestamp - timestamptz	interval
-	timestamptz - interval	timestamptz
-	timestamptz - timestamp	interval
-	timestamptz - timestamptz	interval
-	timetz - interval	timetz
->	jsonb -> INT2	jsonb
->	jsonb -> INT4	jsonb
->	jsonb -> INT8	jsonb
->	jsonb -> STRING	jsonb
->>	jsonb ->> INT2	STRING
->>	jsonb ->> INT4	STRING
->>	jsonb ->> INT8	STRING
->>	jsonb ->> STRING	STRING
/	decimal / decimal	decimal
/	decimal / INT2	decimal
/	decimal / INT4	decimal
/	decimal / INT8	decimal
/	FLOAT4 / FLOAT4	FLOAT8
/	FLOAT4 / FLOAT8	FLOAT8
/	FLOAT8 / FLOAT4	FLOAT8
/	FLOAT8 / FLOAT8	FLOAT8
/	INT2 / decimal	decimal
/	INT4 / decimal	decimal
/	INT8 / decimal	decimal
/	INT2 / INT2	decimal
/	INT2 / INT4	decimal
/	INT2 / INT8	decimal
/	INT4 / INT2	decimal
/	INT4 / INT4	decimal
/	INT4 / INT8	decimal
/	INT8 / INT2	decimal
/	INT8 / INT4	decimal
/	INT8 / INT8	decimal
/	interval / FLOAT4	interval
/	interval / FLOAT8	interval
/	interval / INT2	interval
/	interval / INT4	interval
/	interval / INT8	interval
//	decimal // decimal	decimal
//	decimal // INT2	decimal
//	decimal // INT4	decimal
//	decimal // INT8	decimal
//	FLOAT4 // FLOAT4	FLOAT8
//	FLOAT4 // FLOAT8	FLOAT8
//	FLOAT8 // FLOAT4	FLOAT8
//	FLOAT8 // FLOAT8	FLOAT8
//	INT2 // decimal	decimal
//	INT4 // decimal	decimal
//	INT8 // decimal	decimal
//	INT2 // INT2	INT8
//	INT2 // INT4	INT8
//	INT2 // INT8	INT8
//	INT4 // INT2	INT8
//	INT4 // INT4	INT8
//	INT4 // INT8	INT8
//	INT8 // INT2	INT8
//	INT8 // INT4	INT8
//	INT8 // INT8	INT8
<	BOOL < BOOL	BOOL
<	BOOL[] < BOOL[]	BOOL
<	bytes < bytes	BOOL
<	bytes[] < bytes[]	BOOL
<	collatedSTRING < collatedSTRING	BOOL
<	date < date	BOOL
<	date < timestamp	BOOL
<	date < timestamptz	BOOL
<	decimal < decimal	BOOL
<	decimal < FLOAT4	BOOL
<	decimal < FLOAT8	BOOL
<	decimal < INT2	BOOL
<	decimal < INT4	BOOL
<	decimal < INT8	BOOL
<	decimal[] < decimal[]	BOOL
<	FLOAT4 < decimal	BOOL
<	FLOAT8 < decimal	BOOL
<	FLOAT4 < FLOAT4	BOOL
<	FLOAT4 < FLOAT8	BOOL
<	FLOAT8 < FLOAT4	BOOL
<	FLOAT8 < FLOAT8	BOOL
<	float4 < int2	BOOL
<	float4 < int4	BOOL
<	float4 < int8	BOOL
<	float8 < int2	BOOL
<	float8 < int4	BOOL
<	float8 < int8	BOOL
<	FLOAT4[] < FLOAT4[]	BOOL
<	FLOAT4[] < FLOAT8[]	BOOL
<	FLOAT8[] < FLOAT4[]	BOOL
<	FLOAT8[] < FLOAT8[]	BOOL
<	INET < INET	BOOL
<	INET[] < INET[]	BOOL
<	INT2 < decimal	BOOL
<	INT4 < decimal	BOOL
<	INT8 < decimal	BOOL
<	int2 < float4	BOOL
<	int2 < float8	BOOL
<	int4 < float4	BOOL
<	int4 < float8	BOOL
<	int8 < float4	BOOL
<	int8 < float8	BOOL
<	int2 < int2	BOOL
<	int2 < int4	BOOL
<	int2 < int8	BOOL
<	int4 < int2	BOOL
<	int4 < int4	BOOL
<	int4 < int8	BOOL
<	int8 < int2	BOOL
<	int8 < int4	BOOL
<	int8 < int8	BOOL
<	INT2[] < INT2[]	BOOL
<	INT2[] < INT4[]	BOOL
<	INT2[] < INT8[]	BOOL
<	INT4[] < INT2[]	BOOL
<	INT4[] < INT4[]	BOOL
<	INT4[] < INT8[]	BOOL
<	INT8[] < INT2[]	BOOL
<	INT8[] < INT4[]	BOOL
<	INT8[] < INT8[]	BOOL
<	interval < interval	BOOL
<	interval[] < interval[]	BOOL
<	jsonb < jsonb	BOOL
<	oid < oid	BOOL
<	STRING < STRING	BOOL
<	STRING[] < STRING[]	BOOL
<	time < time	BOOL
<	time < timetz	BOOL
<	time[] < time[]	BOOL
<	timestamp < date	BOOL
<	timestamp < timestamp	BOOL
<	timestamp < timestamptz	BOOL
<	timestamp[] < timestamp[]	BOOL
<	timestamptz < date	BOOL
<	timestamptz < timestamp	BOOL
<	timestamptz < timestamptz	BOOL
<	timestamptz[] < timestamptz[]	BOOL
<	timetz < time	BOOL
<	timetz < timetz	BOOL
<	tuple < tuple	BOOL
<	UUID < UUID	BOOL
<	UUID[] < UUID[]	BOOL
<	varbit < varbit	BOOL
<<	INET << INET	BOOL
<<	int2 << int2	int8
<<	int2 << int4	int8
<<	int2 << int8	int8
<<	int4 << int2	int8
<<	int4 << int4	int8
<<	int4 << int8	int8
<<	int8 << int2	int8
<<	int8 << int4	int8
<<	int8 << int8	int8
<<	varbit << INT2	varbit
<<	varbit << INT4	varbit
<<	varbit << INT8	varbit
<=	BOOL <= BOOL	BOOL
<=	BOOL[] <= BOOL[]	BOOL
<=	bytes <= bytes	BOOL
<=	bytes[] <= bytes[]	BOOL
<=	collatedSTRING <= collatedSTRING	BOOL
<=	date <= date	BOOL
<=	date <= timestamp	BOOL
<=	date <= timestamptz	BOOL
<=	date[] <= date[]	BOOL
<=	decimal <= decimal	BOOL
<=	decimal <= FLOAT4	BOOL
<=	decimal <= FLOAT8	BOOL
<=	decimal <= INT2	BOOL
<=	decimal <= INT4	BOOL
<=	decimal <= INT8	BOOL
<=	decimal[] <= decimal[]	BOOL
<=	FLOAT4 <= decimal	BOOL
<=	FLOAT8 <= decimal	BOOL
<=	float4 <= float4	BOOL
<=	float4 <= float8	BOOL
<=	float8 <= float4	BOOL
<=	float8 <= float8	BOOL
<=	float4 <= int2	BOOL
<=	float4 <= int4	BOOL
<=	float4 <= int8	BOOL
<=	float8 <= int2	BOOL
<=	float8 <= int4	BOOL
<=	float8 <= int8	BOOL
<=	FLOAT4[] <= FLOAT4[]	BOOL
<=	FLOAT4[] <= FLOAT8[]	BOOL
<=	FLOAT8[] <= FLOAT4[]	BOOL
<=	FLOAT8[] <= FLOAT8[]	BOOL
<=	INET <= INET	BOOL
<=	INET[] <= INET[]	BOOL
<=	INT2 <= decimal	BOOL
<=	INT4 <= decimal	BOOL
<=	INT8 <= decimal	BOOL
<=	int2 <= float4	BOOL
<=	int2 <= float8	BOOL
<=	int4 <= float4	BOOL
<=	int4 <= float8	BOOL
<=	int8 <= float4	BOOL
<=	int8 <= float8	BOOL
<=	int2 <= int2	BOOL
<=	int2 <= int4	BOOL
<=	int2 <= int8	BOOL
<=	int4 <= int2	BOOL
<=	int4 <= int4	BOOL
<=	int4 <= int8	BOOL
<=	int8 <= int2	BOOL
<=	int8 <= int4	BOOL
<=	int8 <= int8	BOOL
<=	INT2[] <= INT2[]	BOOL
<=	INT2[] <= INT4[]	BOOL
<=	INT2[] <= INT8[]	BOOL
<=	INT4[] <= INT2[]	BOOL
<=	INT4[] <= INT4[]	BOOL
<=	INT4[] <= INT8[]	BOOL
<=	INT8[] <= INT2[]	BOOL
<=	INT8[] <= INT4[]	BOOL
<=	INT8[] <= INT8[]	BOOL
<=	interval <= interval	BOOL
<=	interval[] <= interval[]	BOOL
<=	jsonb <= jsonb	BOOL
<=	oid <= oid	BOOL
<=	STRING <= STRING	BOOL
<=	STRING[] <= STRING[]	BOOL
<=	time <= time	BOOL
<=	time <= timetz	BOOL
<=	time[] <= time[]	BOOL
<=	timestamp <= date	BOOL
<=	timestamp <= timestamp	BOOL
<=	timestamp <= timestamptz	BOOL
<=	timestamp[] <= timestamp[]	BOOL
<=	timestamptz <= date	BOOL
<=	timestamptz <= timestamp	BOOL
<=	timestamptz <= timestamptz	BOOL
<=	timestamptz[] <= timestamptz[]	BOOL
<=	timetz <= time	BOOL
<=	timetz <= timetz	BOOL
<=	tuple <= tuple	BOOL
<=	UUID <= UUID	BOOL
<=	UUID[] <= UUID[]	BOOL
<=	varbit <= varbit	BOOL
<@	anyelement <@ anyelement	BOOL
<@	jsonb <@ jsonb	BOOL
=	BOOL = BOOL	BOOL
=	BOOL[] = BOOL[]	BOOL
=	bytes = bytes	BOOL
=	bytes[] = bytes[]	BOOL
=	collatedSTRING = collatedSTRING	BOOL
=	date = date	BOOL
=	date = timestamp	BOOL
=	date = timestamptz	BOOL
=	date[] = date[]	BOOL
=	decimal = decimal	BOOL
=	decimal = FLOAT4	BOOL
=	decimal = FLOAT8	BOOL
=	decimal = INT2	BOOL
=	decimal = INT4	BOOL
=	decimal = INT8	BOOL
=	decimal[] = decimal[]	BOOL
=	FLOAT4 = decimal	BOOL
=	FLOAT8 = decimal	BOOL
=	float4 = float4	BOOL
=	float4 = float8	BOOL
=	float8 = float4	BOOL
=	float8 = float8	BOOL
=	float4 = int2	BOOL
=	float4 = int4	BOOL
=	float4 = int8	BOOL
=	float8 = int2	BOOL
=	float8 = int4	BOOL
=	float8 = int8	BOOL
=	FLOAT4[] = FLOAT4[]	BOOL
=	FLOAT4[] = FLOAT8[]	BOOL
=	FLOAT8[] = FLOAT4[]	BOOL
=	FLOAT8[] = FLOAT8[]	BOOL
=	INET = INET	BOOL
=	INET[] = INET[]	BOOL
=	INT2 = decimal	BOOL
=	INT4 = decimal	BOOL
=	INT8 = decimal	BOOL
=	int2 = float4	BOOL
=	int2 = float8	BOOL
=	int4 = float4	BOOL
=	int4 = float8	BOOL
=	int8 = float4	BOOL
=	int8 = float8	BOOL
=	int2 = int2	BOOL
=	int2 = int4	BOOL
=	int2 = int8	BOOL
=	Int4 = int2	BOOL
=	int4 = int4	BOOL
=	int4 = int8	BOOL
=	int8 = int2	BOOL
=	int8 = int4	BOOL
=	int8 = int8	BOOL
=	INT2[] = INT2[]	BOOL
=	INT2[] = INT4[]	BOOL
=	INT2[] = INT8[]	BOOL
=	INT4[] = INT2[]	BOOL
=	INT4[] = INT4[]	BOOL
=	INT4[] = INT8[]	BOOL
=	INT8[] = INT2[]	BOOL
=	INT8[] = INT4[]	BOOL
=	INT8[] = INT8[]	BOOL
=	interval = interval	BOOL
=	interval[] = interval[]	BOOL
=	jsonb = jsonb	BOOL
=	oid = oid	BOOL
=	STRING = STRING	BOOL
=	STRING[] = STRING[]	BOOL
=	time = time	BOOL
=	time = timetz	BOOL
=	time[] = time[]	BOOL
=	timestamp = date	BOOL
=	timestamp = timestamp	BOOL
=	timestamp = timestamptz	BOOL
=	timestamp[] = timestamp[]	BOOL
=	timestamptz = date	BOOL
=	timestamptz = timestamp	BOOL
=	timestamptz = timestamptz	BOOL
=	timestamptz[] = timestamptz[]	BOOL
=	timetz = time	BOOL
=	timetz = timetz	BOOL
=	tuple = tuple	BOOL
=	UUID = UUID	BOOL
=	UUID[] = UUID[]	BOOL
=	varbit = varbit	BOOL
>>	INET >> INET	BOOL
>>	int2 >> int2	int8
>>	int2 >> int4	int8
>>	int2 >> int8	int8
>>	int4 >> int2	int8
>>	int4 >> int4	int8
>>	int4 >> int8	int8
>>	int8 >> int2	int8
>>	int8 >> int4	int8
>>	int8 >> int8	int8
>>	varbit >> INT2	varbit
>>	varbit >> INT4	varbit
>>	varbit >> INT8	varbit
?	jsonb ? STRING	BOOL
?&	jsonb ?& STRING[]	BOOL
?|	jsonb ?| STRING[]	BOOL
@>	anyelement @> anyelement	BOOL
@>	jsonb @> jsonb	BOOL
ILIKE	STRING ILIKE STRING	BOOL
IN	BOOL IN tuple	BOOL
IN	bytes IN tuple	BOOL
IN	collatedSTRING IN tuple	BOOL
IN	date IN tuple	BOOL
IN	decimal IN tuple	BOOL
IN	FLOAT4 IN tuple	BOOL
IN	FLOAT8 IN tuple	BOOL
IN	INET IN tuple	BOOL
IN	INT2 IN tuple	BOOL
IN	INT4 IN tuple	BOOL
IN	INT8 IN tuple	BOOL
IN	interval IN tuple	BOOL
IN	jsonb IN tuple	BOOL
IN	oid IN tuple	BOOL
IN	STRING IN tuple	BOOL
IN	time IN tuple	BOOL
IN	timestamp IN tuple	BOOL
IN	timestamptz IN tuple	BOOL
IN	tuple IN tuple	BOOL
IN	UUID IN tuple	BOOL
IN	varbit IN tuple	BOOL
IS NOT DISTINCT FROM	BOOL IS NOT DISTINCT FROM BOOL	BOOL
IS NOT DISTINCT FROM	BOOL[] IS NOT DISTINCT FROM BOOL[]	BOOL
IS NOT DISTINCT FROM	bytes IS NOT DISTINCT FROM bytes	BOOL
IS NOT DISTINCT FROM	bytes[] IS NOT DISTINCT FROM bytes[]	BOOL
IS NOT DISTINCT FROM	collatedSTRING IS NOT DISTINCT FROM collatedSTRING	BOOL
IS NOT DISTINCT FROM	date IS NOT DISTINCT FROM date	BOOL
IS NOT DISTINCT FROM	date IS NOT DISTINCT FROM timestamp	BOOL
IS NOT DISTINCT FROM	date IS NOT DISTINCT FROM timestamptz	BOOL
IS NOT DISTINCT FROM	date[] IS NOT DISTINCT FROM date[]	BOOL
IS NOT DISTINCT FROM	decimal IS NOT DISTINCT FROM decimal	BOOL
IS NOT DISTINCT FROM	decimal IS NOT DISTINCT FROM FLOAT4	BOOL
IS NOT DISTINCT FROM	decimal IS NOT DISTINCT FROM FLOAT8	BOOL
IS NOT DISTINCT FROM	decimal IS NOT DISTINCT FROM INT2	BOOL
IS NOT DISTINCT FROM	decimal IS NOT DISTINCT FROM INT4	BOOL
IS NOT DISTINCT FROM	decimal IS NOT DISTINCT FROM INT8	BOOL
IS NOT DISTINCT FROM	decimal[] IS NOT DISTINCT FROM decimal[]	BOOL
IS NOT DISTINCT FROM	FLOAT4 IS NOT DISTINCT FROM decimal	BOOL
IS NOT DISTINCT FROM	FLOAT8 IS NOT DISTINCT FROM decimal	BOOL
IS NOT DISTINCT FROM	FLOAT4 IS NOT DISTINCT FROM FLOAT4	BOOL
IS NOT DISTINCT FROM	FLOAT4 IS NOT DISTINCT FROM FLOAT8	BOOL
IS NOT DISTINCT FROM	FLOAT8 IS NOT DISTINCT FROM FLOAT4	BOOL
IS NOT DISTINCT FROM	FLOAT8 IS NOT DISTINCT FROM FLOAT8	BOOL
IS NOT DISTINCT FROM	FLOAT4 IS NOT DISTINCT FROM INT2	BOOL
IS NOT DISTINCT FROM	FLOAT4 IS NOT DISTINCT FROM INT4	BOOL
IS NOT DISTINCT FROM	FLOAT4 IS NOT DISTINCT FROM INT8	BOOL
IS NOT DISTINCT FROM	FLOAT8 IS NOT DISTINCT FROM INT2	BOOL
IS NOT DISTINCT FROM	FLOAT8 IS NOT DISTINCT FROM INT4	BOOL
IS NOT DISTINCT FROM	FLOAT8 IS NOT DISTINCT FROM INT8	BOOL
IS NOT DISTINCT FROM	FLOAT4[] IS NOT DISTINCT FROM FLOAT4[]	BOOL
IS NOT DISTINCT FROM	FLOAT4[] IS NOT DISTINCT FROM FLOAT8[]	BOOL
IS NOT DISTINCT FROM	FLOAT8[] IS NOT DISTINCT FROM FLOAT4[]	BOOL
IS NOT DISTINCT FROM	FLOAT8[] IS NOT DISTINCT FROM FLOAT8[]	BOOL
IS NOT DISTINCT FROM	INET IS NOT DISTINCT FROM INET	BOOL
IS NOT DISTINCT FROM	INET[] IS NOT DISTINCT FROM INET[]	BOOL
IS NOT DISTINCT FROM	INT2 IS NOT DISTINCT FROM decimal	BOOL
IS NOT DISTINCT FROM	INT4 IS NOT DISTINCT FROM decimal	BOOL
IS NOT DISTINCT FROM	INT8 IS NOT DISTINCT FROM decimal	BOOL
IS NOT DISTINCT FROM	INT2 IS NOT DISTINCT FROM FLOAT4	BOOL
IS NOT DISTINCT FROM	INT2 IS NOT DISTINCT FROM FLOAT8	BOOL
IS NOT DISTINCT FROM	INT4 IS NOT DISTINCT FROM FLOAT4	BOOL
IS NOT DISTINCT FROM	INT4 IS NOT DISTINCT FROM FLOAT8	BOOL
IS NOT DISTINCT FROM	INT8 IS NOT DISTINCT FROM FLOAT4	BOOL
IS NOT DISTINCT FROM	INT8 IS NOT DISTINCT FROM FLOAT8	BOOL
IS NOT DISTINCT FROM	INT2 IS NOT DISTINCT FROM INT2	BOOL
IS NOT DISTINCT FROM	INT2 IS NOT DISTINCT FROM INT4	BOOL
IS NOT DISTINCT FROM	INT2 IS NOT DISTINCT FROM INT8	BOOL
IS NOT DISTINCT FROM	INT4 IS NOT DISTINCT FROM INT2	BOOL
IS NOT DISTINCT FROM	INT4 IS NOT DISTINCT FROM INT4	BOOL
IS NOT DISTINCT FROM	INT4 IS NOT DISTINCT FROM INT8	BOOL
IS NOT DISTINCT FROM	INT8 IS NOT DISTINCT FROM INT2	BOOL
IS NOT DISTINCT FROM	INT8 IS NOT DISTINCT FROM INT4	BOOL
IS NOT DISTINCT FROM	INT8 IS NOT DISTINCT FROM INT8	BOOL
IS NOT DISTINCT FROM	INT2[] IS NOT DISTINCT FROM INT2[]	BOOL
IS NOT DISTINCT FROM	INT2[] IS NOT DISTINCT FROM INT4[]	BOOL
IS NOT DISTINCT FROM	INT2[] IS NOT DISTINCT FROM INT8[]	BOOL
IS NOT DISTINCT FROM	INT4[] IS NOT DISTINCT FROM INT2[]	BOOL
IS NOT DISTINCT FROM	INT4[] IS NOT DISTINCT FROM INT4[]	BOOL
IS NOT DISTINCT FROM	INT4[] IS NOT DISTINCT FROM INT8[]	BOOL
IS NOT DISTINCT FROM	INT8[] IS NOT DISTINCT FROM INT2[]	BOOL
IS NOT DISTINCT FROM	INT8[] IS NOT DISTINCT FROM INT4[]	BOOL
IS NOT DISTINCT FROM	INT8[] IS NOT DISTINCT FROM INT8[]	BOOL
IS NOT DISTINCT FROM	interval IS NOT DISTINCT FROM interval	BOOL
IS NOT DISTINCT FROM	interval[] IS NOT DISTINCT FROM interval[]	BOOL
IS NOT DISTINCT FROM	jsonb IS NOT DISTINCT FROM jsonb	BOOL
IS NOT DISTINCT FROM	oid IS NOT DISTINCT FROM oid	BOOL
IS NOT DISTINCT FROM	STRING IS NOT DISTINCT FROM STRING	BOOL
IS NOT DISTINCT FROM	STRING[] IS NOT DISTINCT FROM STRING[]	BOOL
IS NOT DISTINCT FROM	time IS NOT DISTINCT FROM time	BOOL
IS NOT DISTINCT FROM	time IS NOT DISTINCT FROM timetz	BOOL
IS NOT DISTINCT FROM	time[] IS NOT DISTINCT FROM time[]	BOOL
IS NOT DISTINCT FROM	timestamp IS NOT DISTINCT FROM date	BOOL
IS NOT DISTINCT FROM	timestamp IS NOT DISTINCT FROM timestamp	BOOL
IS NOT DISTINCT FROM	timestamp IS NOT DISTINCT FROM timestamptz	BOOL
IS NOT DISTINCT FROM	timestamp[] IS NOT DISTINCT FROM timestamp[]	BOOL
IS NOT DISTINCT FROM	timestamptz IS NOT DISTINCT FROM date	BOOL
IS NOT DISTINCT FROM	timestamptz IS NOT DISTINCT FROM timestamp	BOOL
IS NOT DISTINCT FROM	timestamptz IS NOT DISTINCT FROM timestamptz	BOOL
IS NOT DISTINCT FROM	timetz IS NOT DISTINCT FROM time	BOOL
IS NOT DISTINCT FROM	timetz IS NOT DISTINCT FROM timetz	BOOL
IS NOT DISTINCT FROM	tuple IS NOT DISTINCT FROM tuple	BOOL
IS NOT DISTINCT FROM	unknown IS NOT DISTINCT FROM unknown	BOOL
IS NOT DISTINCT FROM	UUID IS NOT DISTINCT FROM UUID	BOOL
IS NOT DISTINCT FROM	UUID[] IS NOT DISTINCT FROM UUID[]	BOOL
IS NOT DISTINCT FROM	varbit IS NOT DISTINCT FROM varbit	BOOL
LIKE	STRING LIKE STRING	BOOL
SIMILAR TO	STRING SIMILAR TO STRING	BOOL
^	decimal ^ decimal	decimal
^	decimal ^ INT2	decimal
^	decimal ^ INT4	decimal
^	decimal ^ INT8	decimal
^	FLOAT4 ^ FLOAT4	FLOAT8
^	FLOAT4 ^ FLOAT8	FLOAT8
^	FLOAT8 ^ FLOAT4	FLOAT8
^	FLOAT8 ^ FLOAT8	FLOAT8
^	INT2 ^ decimal	decimal
^	INT4 ^ decimal	decimal
^	INT8 ^ decimal	decimal
^	INT2 ^ INT2	INT8
^	INT2 ^ INT4	INT8
^	INT2 ^ INT8	INT8
^	INT4 ^ INT2	INT8
^	INT4 ^ INT4	INT8
^	INT4 ^ INT8	INT8
^	INT8 ^ INT2	INT8
^	INT8 ^ INT4	INT8
^	INT8 ^ INT8	INT8
|	INET | INET	INET
|	INT2 | INT2	INT8
|	INT2 | INT4	INT8
|	INT2 | INT8	INT8
|	INT4 | INT2	INT8
|	INT4 | INT4	INT8
|	INT4 | INT8	INT8
|	INT8 | INT2	INT8
|	INT8 | INT4	INT8
|	INT8 | INT8	INT8
|	varbit | varbit	varbit
||	BOOL || BOOL[]	BOOL[]
||	BOOL[] || BOOL	BOOL[]
||	BOOL[] || BOOL[]	BOOL[]
||	bytes || bytes	bytes
||	bytes || bytes[]	bytes[]
||	bytes[] || bytes	bytes[]
||	bytes[] || bytes[]	bytes[]
||	date || date[]	date[]
||	date[] || date	date[]
||	date[] || date[]	date[]
||	decimal || decimal[]	decimal[]
||	decimal[] || decimal	decimal[]
||	decimal[] || decimal[]	decimal[]
||	FLOAT4 || FLOAT4[]	FLOAT8[]
||	FLOAT4 || FLOAT8[]	FLOAT8[]
||	FLOAT8 || FLOAT4[]	FLOAT8[]
||	FLOAT8 || FLOAT8[]	FLOAT8[]
||	FLOAT4[] || FLOAT4	FLOAT8[]
||	FLOAT4[] || FLOAT8	FLOAT8[]
||	FLOAT8[] || FLOAT4	FLOAT8[]
||	FLOAT8[] || FLOAT8	FLOAT8[]
||	FLOAT4[] || FLOAT4[]	FLOAT8[]
||	FLOAT4[] || FLOAT8[]	FLOAT8[]
||	FLOAT8[] || FLOAT4[]	FLOAT8[]
||	FLOAT8[] || FLOAT8[]	FLOAT8[]
||	INET || INET[]	INET[]
||	INET[] || INET	INET[]
||	INET[] || INET[]	INET[]
||	INT2 || INT2[]	INT8[]
||	INT2 || INT4[]	INT8[]
||	INT2 || INT8[]	INT8[]
||	INT4 || INT2[]	INT8[]
||	INT4 || INT4[]	INT8[]
||	INT4 || INT8[]	INT8[]
||	INT8 || INT2[]	INT8[]
||	INT8 || INT4[]	INT8[]
||	INT8 || INT8[]	INT8[]
||	INT2[] || INT2	INT8[]
||	INT2[] || INT4	INT8[]
||	INT2[] || INT8	INT8[]
||	INT4[] || INT2	INT8[]
||	INT4[] || INT4	INT8[]
||	INT4[] || INT8	INT8[]
||	INT8[] || INT2	INT8[]
||	INT8[] || INT4	INT8[]
||	INT8[] || INT8	INT8[]
||	INT2[] || INT2[]	INT8[]
||	INT2[] || INT4[]	INT8[]
||	INT2[] || INT8[]	INT8[]
||	INT4[] || INT2[]	INT8[]
||	INT4[] || INT4[]	INT8[]
||	INT4[] || INT8[]	INT8[]
||	INT8[] || INT2[]	INT8[]
||	INT8[] || INT4[]	INT8[]
||	INT8[] || INT8[]	INT8[]
||	interval || interval[]	interval[]
||	interval[] || interval	interval[]
||	interval[] || interval[]	interval[]
||	jsonb || jsonb	jsonb
||	oid || oid	oid
||	STRING || STRING	STRING
||	STRING || STRING[]	STRING[]
||	STRING[] || STRING	STRING[]
||	STRING[] || STRING[]	STRING[]
||	time || time[]	time[]
||	time[] || time	time[]
||	time[] || time[]	time[]
||	timestamp || timestamp[]	timestamp[]
||	timestamp[] || timestamp	timestamp[]
||	timestamp[] || timestamp[]	timestamp[]
||	timestamptz || timestamptz[]	timestamptz
||	timestamptz[] || timestamptz	timestamptz
||	timestamptz[] || timestamptz[]	timestamptz
||	timetz || timetz	timetz
||	UUID || UUID[]	UUID[]
||	UUID[] || UUID	UUID[]
||	UUID[] || UUID[]	UUID[]
||	varbit || varbit	varbit
~	~INET	INET
~	~INT2	INT8
~	~INT4	INT8
~	~INT8	INT8
~	~varbit	varbit
~	STRING ~ STRING	BOOL
~*	STRING ~* STRING	BOOL