Wiki / Operators
Operators
Compare versionsOperator overloads with operand and result types, implementation functions and index membership.
Reading PostgreSQL 18.6.
865 entries; 799 recorded in PostgreSQL 18.6.
-
#(bit,bit) Bit strings
bitwise exclusive or
-
&(bit,bit) Bit strings
bitwise and
-
<(bit,bit) Bit strings
less than
-
<(varbit,varbit) Bit strings
less than
-
<<(bit,int4) Bit strings
bitwise shift left
-
<=(bit,bit) Bit strings
less than or equal
-
<=(varbit,varbit) Bit strings
less than or equal
-
<>(bit,bit) Bit strings
not equal
-
<>(varbit,varbit) Bit strings
not equal
-
=(bit,bit) Bit strings
equal
-
=(varbit,varbit) Bit strings
equal
-
>(bit,bit) Bit strings
greater than
-
>(varbit,varbit) Bit strings
greater than
-
>=(bit,bit) Bit strings
greater than or equal
-
>=(varbit,varbit) Bit strings
greater than or equal
-
>>(bit,int4) Bit strings
bitwise shift right
-
|(bit,bit) Bit strings
bitwise or
-
||(varbit,varbit) Bit strings
concatenate
-
~(none,bit) Bit strings
bitwise not
-
<(bool,bool) Boolean
less than
-
<=(bool,bool) Boolean
less than or equal
-
<>(bool,bool) Boolean
not equal
-
=(bool,bool) Boolean
equal
-
>(bool,bool) Boolean
greater than
-
>=(bool,bool) Boolean
greater than or equal
-
!~(bpchar,text) Character strings
does not match regular expression, case-sensitive
-
!~(name,text) Character strings
does not match regular expression, case-sensitive
-
!~(text,text) Character strings
does not match regular expression, case-sensitive
-
!~*(bpchar,text) Character strings
does not match regular expression, case-insensitive
-
!~*(name,text) Character strings
does not match regular expression, case-insensitive
-
!~*(text,text) Character strings
does not match regular expression, case-insensitive
-
!~~(bpchar,text) Character strings
does not match LIKE expression
-
!~~(name,text) Character strings
does not match LIKE expression
-
!~~(text,text) Character strings
does not match LIKE expression
-
!~~*(bpchar,text) Character strings
does not match LIKE expression, case-insensitive
-
!~~*(name,text) Character strings
does not match LIKE expression, case-insensitive
-
!~~*(text,text) Character strings
does not match LIKE expression, case-insensitive
-
<(bpchar,bpchar) Character strings
less than
-
<(char,char) Character strings
less than
-
<(name,name) Character strings
less than
-
<(name,text) Character strings
less than
-
<(text,name) Character strings
less than
-
<(text,text) Character strings
less than
-
<=(bpchar,bpchar) Character strings
less than or equal
-
<=(char,char) Character strings
less than or equal
-
<=(name,name) Character strings
less than or equal
-
<=(name,text) Character strings
less than or equal
-
<=(text,name) Character strings
less than or equal
-
<=(text,text) Character strings
less than or equal
-
<>(bpchar,bpchar) Character strings
not equal
-
<>(char,char) Character strings
not equal
-
<>(name,name) Character strings
not equal
-
<>(name,text) Character strings
not equal
-
<>(text,name) Character strings
not equal
-
<>(text,text) Character strings
not equal
-
=(bpchar,bpchar) Character strings
equal
-
=(char,char) Character strings
equal
-
=(name,name) Character strings
equal
-
=(name,text) Character strings
equal
-
=(text,name) Character strings
equal
-
=(text,text) Character strings
equal
-
>(bpchar,bpchar) Character strings
greater than
-
>(char,char) Character strings
greater than
-
>(name,name) Character strings
greater than
-
>(name,text) Character strings
greater than
-
>(text,name) Character strings
greater than
-
>(text,text) Character strings
greater than
-
>=(bpchar,bpchar) Character strings
greater than or equal
-
>=(char,char) Character strings
greater than or equal
-
>=(name,name) Character strings
greater than or equal
-
>=(name,text) Character strings
greater than or equal
-
>=(text,name) Character strings
greater than or equal
-
>=(text,text) Character strings
greater than or equal
-
@@(text,text) Character strings
text search match
-
@@(text,tsquery) Character strings
text search match
-
^@(text,text) Character strings
starts with
-
||(text,anynonarray) Character strings
concatenate
-
||(text,text) Character strings
concatenate
-
~(bpchar,text) Character strings
matches regular expression, case-sensitive
-
~(name,text) Character strings
matches regular expression, case-sensitive
-
~(text,text) Character strings
matches regular expression, case-sensitive
-
~*(bpchar,text) Character strings
matches regular expression, case-insensitive
-
~*(name,text) Character strings
matches regular expression, case-insensitive
-
~*(text,text) Character strings
matches regular expression, case-insensitive
-
~<=~(bpchar,bpchar) Character strings
less than or equal
-
~<=~(text,text) Character strings
less than or equal
-
~<~(bpchar,bpchar) Character strings
less than
-
~<~(text,text) Character strings
less than
-
~>=~(bpchar,bpchar) Character strings
greater than or equal
-
~>=~(text,text) Character strings
greater than or equal
-
~>~(bpchar,bpchar) Character strings
greater than
-
~>~(text,text) Character strings
greater than
-
~~(bpchar,text) Character strings
matches LIKE expression
-
~~(name,text) Character strings
matches LIKE expression
-
~~(text,text) Character strings
matches LIKE expression
-
~~*(bpchar,text) Character strings
matches LIKE expression, case-insensitive
-
~~*(name,text) Character strings
matches LIKE expression, case-insensitive
-
~~*(text,text) Character strings
matches LIKE expression, case-insensitive
-
Not recorded in the selected version.
-
Not recorded in the selected version.
RecordedFirst recordedInterface or attribute changeNo longer recorded
Squares indicate presence in sampled builds, not first introduction. Select a square for the same-version definition and sources.
Changes in PostgreSQL 18.6 · Export JSON
Reading this collection
Every core bootstrap overload in the sampled builds has its own operand signature. Operator-family membership identifies a specific strategy or ordering purpose; it does not guarantee that an arbitrary query can use an index.