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.
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
*(interval,float8) Date and time
multiply
-
Not recorded in the selected version.
-
+(date,int4) Date and time
add
-
+(date,interval) Date and time
add
-
+(date,time) Date and time
convert date and time to timestamp
-
+(date,timetz) Date and time
convert date and time with time zone to timestamp with time zone
-
+(interval,date) Date and time
add
-
+(interval,interval) Date and time
add
-
+(interval,time) Date and time
add
-
+(interval,timestamp) Date and time
add
-
+(interval,timestamptz) Date and time
add
-
+(interval,timetz) Date and time
add
-
+(time,date) Date and time
convert time and date to timestamp
-
+(time,interval) Date and time
add
-
+(timestamp,interval) Date and time
add
-
+(timestamptz,interval) Date and time
add
-
+(timetz,date) Date and time
convert time with time zone and date to timestamp with time zone
-
+(timetz,interval) Date and time
add
-
Not recorded in the selected version.
-
-(date,date) Date and time
subtract
-
-(date,int4) Date and time
subtract
-
-(date,interval) Date and time
subtract
-
-(interval,interval) Date and time
subtract
-
-(none,interval) Date and time
negate
-
-(time,interval) Date and time
subtract
-
-(time,time) Date and time
subtract
-
-(timestamp,interval) Date and time
subtract
-
-(timestamp,timestamp) Date and time
subtract
-
-(timestamptz,interval) Date and time
subtract
-
-(timestamptz,timestamptz) Date and time
subtract
-
-(timetz,interval) Date and time
subtract
-
/(interval,float8) Date and time
divide
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
<(date,date) Date and time
less than
-
<(date,timestamp) Date and time
less than
-
<(date,timestamptz) Date and time
less than
-
<(interval,interval) Date and time
less than
-
Not recorded in the selected version.
-
<(time,time) Date and time
less than
-
<(timestamp,date) Date and time
less than
-
<(timestamp,timestamp) Date and time
less than
-
<(timestamp,timestamptz) Date and time
less than
-
<(timestamptz,date) Date and time
less than
-
<(timestamptz,timestamp) Date and time
less than
-
<(timestamptz,timestamptz) Date and time
less than
-
<(timetz,timetz) Date and time
less than
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
<=(date,date) Date and time
less than or equal
-
<=(date,timestamp) Date and time
less than or equal
-
<=(date,timestamptz) Date and time
less than or equal
-
<=(interval,interval) Date and time
less than or equal
-
Not recorded in the selected version.
-
<=(time,time) Date and time
less than or equal
-
<=(timestamp,date) Date and time
less than or equal
-
<=(timestamp,timestamp) Date and time
less than or equal
-
<=(timestamp,timestamptz) Date and time
less than or equal
-
<=(timestamptz,date) Date and time
less than or equal
-
<=(timestamptz,timestamp) Date and time
less than or equal
-
<=(timestamptz,timestamptz) Date and time
less than or equal
-
<=(timetz,timetz) Date and time
less than or equal
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
<>(date,date) Date and time
not equal
-
<>(date,timestamp) Date and time
not equal
-
<>(date,timestamptz) Date and time
not equal
-
<>(interval,interval) Date and time
not equal
-
Not recorded in the selected version.
-
<>(time,time) Date and time
not equal
-
<>(timestamp,date) Date and time
not equal
-
<>(timestamp,timestamp) Date and time
not equal
-
<>(timestamp,timestamptz) Date and time
not equal
-
<>(timestamptz,date) Date and time
not equal
-
<>(timestamptz,timestamp) Date and time
not equal
-
<>(timestamptz,timestamptz) Date and time
not equal
-
<>(timetz,timetz) Date and time
not equal
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
Not recorded in the selected version.
-
=(date,date) Date and time
equal
-
=(date,timestamp) Date and time
equal
-
=(date,timestamptz) Date and time
equal
-
=(interval,interval) Date and time
equal
-
Not recorded in the selected version.
-
=(time,time) Date and time
equal
-
=(timestamp,date) Date and time
equal
-
=(timestamp,timestamp) Date and time
equal
-
=(timestamp,timestamptz) Date and time
equal
-
=(timestamptz,date) Date and time
equal
-
=(timestamptz,timestamp) Date and time
equal
-
=(timestamptz,timestamptz) Date and time
equal
-
=(timetz,timetz) Date and time
equal
-
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.