Wiki / Operators

Definitions for PostgreSQL 18

• !!(none,tsquery)Text search10 – 20

  NOT tsquery

  1011121314151617181920
• !~(bpchar,text)Character strings10 – 20

  does not match regular expression, case-sensitive

  1011121314151617181920
• !~(name,text)Character strings10 – 20

  does not match regular expression, case-sensitive

  1011121314151617181920
• !~(text,text)Character strings10 – 20

  does not match regular expression, case-sensitive

  1011121314151617181920
• !~*(bpchar,text)Character strings10 – 20

  does not match regular expression, case-insensitive

  1011121314151617181920
• !~*(name,text)Character strings10 – 20

  does not match regular expression, case-insensitive

  1011121314151617181920
• !~*(text,text)Character strings10 – 20

  does not match regular expression, case-insensitive

  1011121314151617181920
• !~~(bpchar,text)Character strings10 – 20

  does not match LIKE expression

  1011121314151617181920
• !~~(bytea,bytea)Other built-in types10 – 20

  does not match LIKE expression

  1011121314151617181920
• !~~(name,text)Character strings10 – 20

  does not match LIKE expression

  1011121314151617181920
• !~~(text,text)Character strings10 – 20

  does not match LIKE expression

  1011121314151617181920
• !~~*(bpchar,text)Character strings10 – 20

  does not match LIKE expression, case-insensitive

  1011121314151617181920
• !~~*(name,text)Character strings10 – 20

  does not match LIKE expression, case-insensitive

  1011121314151617181920
• !~~*(text,text)Character strings10 – 20

  does not match LIKE expression, case-insensitive

  1011121314151617181920
• ##(line,lseg)Geometric10 – 20

  closest point to A on B

  1011121314151617181920
• ##(lseg,box)Geometric10 – 20

  closest point to A on B

  1011121314151617181920
• ##(lseg,lseg)Geometric10 – 20

  closest point to A on B

  1011121314151617181920
• ##(point,box)Geometric10 – 20

  closest point to A on B

  1011121314151617181920
• ##(point,line)Geometric10 – 20

  closest point to A on B

  1011121314151617181920
• ##(point,lseg)Geometric10 – 20

  closest point to A on B

  1011121314151617181920
• #(bit,bit)Bit strings10 – 20

  bitwise exclusive or

  1011121314151617181920
• #(box,box)Geometric10 – 20

  box intersection

  1011121314151617181920
• #(int2,int2)Numeric10 – 20

  bitwise exclusive or

  1011121314151617181920
• #(int4,int4)Numeric10 – 20

  bitwise exclusive or

  1011121314151617181920
• #(int8,int8)Numeric10 – 20

  bitwise exclusive or

  1011121314151617181920
• #(line,line)Geometric10 – 20

  intersection point

  1011121314151617181920
• #(lseg,lseg)Geometric10 – 20

  intersection point

  1011121314151617181920
• #(none,path)Geometric10 – 20

  number of points

  1011121314151617181920
• #(none,polygon)Geometric10 – 20

  number of points

  1011121314151617181920
• #-(jsonb,_text)JSON10 – 20

  delete path

  1011121314151617181920
• #>(json,_text)JSON10 – 20

  get value from json with path elements

  1011121314151617181920
• #>(jsonb,_text)JSON10 – 20

  get value from jsonb with path elements

  1011121314151617181920
• #>>(json,_text)JSON10 – 20

  get value from json as text with path elements

  1011121314151617181920
• #>>(jsonb,_text)JSON10 – 20

  get value from jsonb as text with path elements

  1011121314151617181920
• %(int2,int2)Numeric10 – 20

  modulus

  1011121314151617181920
• %(int4,int4)Numeric10 – 20

  modulus

  1011121314151617181920
• %(int8,int8)Numeric10 – 20

  modulus

  1011121314151617181920
• %(numeric,numeric)Numeric10 – 20

  modulus

  1011121314151617181920
• &&(anyarray,anyarray)Pseudo-types10 – 20

  overlaps

  1011121314151617181920
• &&(anymultirange,anymultirange)Pseudo-types14 – 20

  overlaps

  1011121314151617181920
• &&(anymultirange,anyrange)Pseudo-types14 – 20

  overlaps

  1011121314151617181920
• &&(anyrange,anymultirange)Pseudo-types14 – 20

  overlaps

  1011121314151617181920
• &&(anyrange,anyrange)Pseudo-types10 – 20

  overlaps

  1011121314151617181920
• &&(box,box)Geometric10 – 20

  overlaps

  1011121314151617181920
• &&(circle,circle)Geometric10 – 20

  overlaps

  1011121314151617181920
• &&(inet,inet)Network addresses10 – 20

  overlaps (is subnet or supernet)

  1011121314151617181920
• &&(polygon,polygon)Geometric10 – 20

  overlaps

  1011121314151617181920
• &&(tsquery,tsquery)Text search10 – 20

  AND-concatenate

  1011121314151617181920
• &(bit,bit)Bit strings10 – 20

  bitwise and

  1011121314151617181920
• &(inet,inet)Network addresses10 – 20

  bitwise and

  1011121314151617181920
• &(int2,int2)Numeric10 – 20

  bitwise and

  1011121314151617181920
• &(int4,int4)Numeric10 – 20

  bitwise and

  1011121314151617181920
• &(int8,int8)Numeric10 – 20

  bitwise and

  1011121314151617181920
• &(macaddr,macaddr)Other built-in types10 – 20

  bitwise and

  1011121314151617181920
• &(macaddr8,macaddr8)Other built-in types10 – 20

  bitwise and

  1011121314151617181920
• &<(anymultirange,anymultirange)Pseudo-types14 – 20

  overlaps or is left of

  1011121314151617181920
• &<(anymultirange,anyrange)Pseudo-types14 – 20

  overlaps or is left of

  1011121314151617181920
• &<(anyrange,anymultirange)Pseudo-types14 – 20

  overlaps or is left of

  1011121314151617181920
• &<(anyrange,anyrange)Pseudo-types10 – 20

  overlaps or is left of

  1011121314151617181920
• &<(box,box)Geometric10 – 20

  overlaps or is left of

  1011121314151617181920
• &<(circle,circle)Geometric10 – 20

  overlaps or is left of

  1011121314151617181920
• &<(polygon,polygon)Geometric10 – 20

  overlaps or is left of

  1011121314151617181920
• &<|(box,box)Geometric10 – 20

  overlaps or is below

  1011121314151617181920
• &<|(circle,circle)Geometric10 – 20

  overlaps or is below

  1011121314151617181920
• &<|(polygon,polygon)Geometric10 – 20

  overlaps or is below

  1011121314151617181920
• &>(anymultirange,anymultirange)Pseudo-types14 – 20

  overlaps or is right of

  1011121314151617181920
• &>(anymultirange,anyrange)Pseudo-types14 – 20

  overlaps or is right of

  1011121314151617181920
• &>(anyrange,anymultirange)Pseudo-types14 – 20

  overlaps or is right of

  1011121314151617181920
• &>(anyrange,anyrange)Pseudo-types10 – 20

  overlaps or is right of

  1011121314151617181920
• &>(box,box)Geometric10 – 20

  overlaps or is right of

  1011121314151617181920
• &>(circle,circle)Geometric10 – 20

  overlaps or is right of

  1011121314151617181920
• &>(polygon,polygon)Geometric10 – 20

  overlaps or is right of

  1011121314151617181920
• *(anymultirange,anymultirange)Pseudo-types14 – 20

  multirange intersect

  1011121314151617181920
• *(anyrange,anyrange)Pseudo-types10 – 20

  range intersection

  1011121314151617181920
• *(box,point)Geometric10 – 20

  multiply box by point (scale)

  1011121314151617181920
• *(circle,point)Geometric10 – 20

  multiply

  1011121314151617181920
• *(float4,float4)Numeric10 – 20

  multiply

  1011121314151617181920
• *(float4,float8)Numeric10 – 20

  multiply

  1011121314151617181920
• *(float4,money)Numeric10 – 20

  multiply

  1011121314151617181920
• *(float8,float4)Numeric10 – 20

  multiply

  1011121314151617181920
• *(float8,float8)Numeric10 – 20

  multiply

  1011121314151617181920
• *(float8,interval)Numeric10 – 20

  multiply

  1011121314151617181920
• *(float8,money)Numeric10 – 20

  multiply

  1011121314151617181920
• *(int2,int2)Numeric10 – 20

  multiply

  1011121314151617181920
• *(int2,int4)Numeric10 – 20

  multiply

  1011121314151617181920
• *(int2,int8)Numeric10 – 20

  multiply

  1011121314151617181920
• *(int2,money)Numeric10 – 20

  multiply

  1011121314151617181920
• *(int4,int2)Numeric10 – 20

  multiply

  1011121314151617181920
• *(int4,int4)Numeric10 – 20

  multiply

  1011121314151617181920
• *(int4,int8)Numeric10 – 20

  multiply

  1011121314151617181920
• *(int4,money)Numeric10 – 20

  multiply

  1011121314151617181920
• *(int8,int2)Numeric10 – 20

  multiply

  1011121314151617181920
• *(int8,int4)Numeric10 – 20

  multiply

  1011121314151617181920
• *(int8,int8)Numeric10 – 20

  multiply

  1011121314151617181920
• *(int8,money)Numeric10 – 20

  multiply

  1011121314151617181920
• *(interval,float8)Date and time10 – 20

  multiply

  1011121314151617181920
• *(money,float4)Numeric10 – 20

  multiply

  1011121314151617181920
• *(money,float8)Numeric10 – 20

  multiply

  1011121314151617181920
• *(money,int2)Numeric10 – 20

  multiply

  1011121314151617181920
• *(money,int4)Numeric10 – 20

  multiply

  1011121314151617181920
• *(money,int8)Numeric10 – 20

  multiply

  1011121314151617181920
• *(numeric,numeric)Numeric10 – 20

  multiply

  1011121314151617181920
• *(path,point)Geometric10 – 20

  multiply (rotate/scale path)

  1011121314151617181920
• *(point,point)Geometric10 – 20

  multiply points (scale/rotate)

  1011121314151617181920
• *<(record,record)Pseudo-types10 – 20

  less than

  1011121314151617181920
• *<=(record,record)Pseudo-types10 – 20

  less than or equal

  1011121314151617181920
• *<>(record,record)Pseudo-types10 – 20

  not identical

  1011121314151617181920
• *=(record,record)Pseudo-types10 – 20

  identical

  1011121314151617181920
• *>(record,record)Pseudo-types10 – 20

  greater than

  1011121314151617181920
• *>=(record,record)Pseudo-types10 – 20

  greater than or equal

  1011121314151617181920
• +(_aclitem,aclitem)Internal and special-purpose10 – 20

  add/update ACL item

  1011121314151617181920
• +(anymultirange,anymultirange)Pseudo-types14 – 20

  multirange union

  1011121314151617181920
• +(anyrange,anyrange)Pseudo-types10 – 20

  range union

  1011121314151617181920
• +(box,point)Geometric10 – 20

  add point to box (translate)

  1011121314151617181920
• +(circle,point)Geometric10 – 20

  add

  1011121314151617181920
• +(date,int4)Date and time10 – 20

  add

  1011121314151617181920
• +(date,interval)Date and time10 – 20

  add

  1011121314151617181920
• +(date,time)Date and time10 – 20

  convert date and time to timestamp

  1011121314151617181920
• +(date,timetz)Date and time10 – 20

  convert date and time with time zone to timestamp with time zone

  1011121314151617181920
• +(float4,float4)Numeric10 – 20

  add

  1011121314151617181920
• +(float4,float8)Numeric10 – 20

  add

  1011121314151617181920
• +(float8,float4)Numeric10 – 20

  add

  1011121314151617181920
• +(float8,float8)Numeric10 – 20

  add

  1011121314151617181920
• +(inet,int8)Network addresses10 – 20

  add

  1011121314151617181920
• +(int2,int2)Numeric10 – 20

  add

  1011121314151617181920
• +(int2,int4)Numeric10 – 20

  add

  1011121314151617181920
• +(int2,int8)Numeric10 – 20

  add

  1011121314151617181920
• +(int4,date)Numeric10 – 20

  add

  1011121314151617181920
• +(int4,int2)Numeric10 – 20

  add

  1011121314151617181920
• +(int4,int4)Numeric10 – 20

  add

  1011121314151617181920
• +(int4,int8)Numeric10 – 20

  add

  1011121314151617181920
• +(int8,inet)Numeric10 – 20

  add

  1011121314151617181920
• +(int8,int2)Numeric10 – 20

  add

  1011121314151617181920
• +(int8,int4)Numeric10 – 20

  add

  1011121314151617181920
• +(int8,int8)Numeric10 – 20

  add

  1011121314151617181920
• +(interval,date)Date and time10 – 20

  add

  1011121314151617181920
• +(interval,interval)Date and time10 – 20

  add

  1011121314151617181920
• +(interval,time)Date and time10 – 20

  add

  1011121314151617181920
• +(interval,timestamp)Date and time10 – 20

  add

  1011121314151617181920
• +(interval,timestamptz)Date and time10 – 20

  add

  1011121314151617181920
• +(interval,timetz)Date and time10 – 20

  add

  1011121314151617181920
• +(money,money)Numeric10 – 20

  add

  1011121314151617181920
• +(none,float4)Numeric10 – 20

  unary plus

  1011121314151617181920
• +(none,float8)Numeric10 – 20

  unary plus

  1011121314151617181920
• +(none,int2)Numeric10 – 20

  unary plus

  1011121314151617181920
• +(none,int4)Numeric10 – 20

  unary plus

  1011121314151617181920
• +(none,int8)Numeric10 – 20

  unary plus

  1011121314151617181920
• +(none,numeric)Numeric10 – 20

  unary plus

  1011121314151617181920
• +(numeric,numeric)Numeric10 – 20

  add

  1011121314151617181920
• +(numeric,pg_lsn)Numeric14 – 20

  add

  1011121314151617181920
• +(path,path)Geometric10 – 20

  concatenate

  1011121314151617181920
• +(path,point)Geometric10 – 20

  add (translate path)

  1011121314151617181920
• +(pg_lsn,numeric)Other built-in types14 – 20

  add

  1011121314151617181920
• +(point,point)Geometric10 – 20

  add points (translate)

  1011121314151617181920
• +(time,date)Date and time10 – 20

  convert time and date to timestamp

  1011121314151617181920
• +(time,interval)Date and time10 – 20

  add

  1011121314151617181920
• +(timestamp,interval)Date and time10 – 20

  add

  1011121314151617181920
• +(timestamptz,interval)Date and time10 – 20

  add

  1011121314151617181920
• +(timetz,date)Date and time10 – 20

  convert time with time zone and date to timestamp with time zone

  1011121314151617181920
• +(timetz,interval)Date and time10 – 20

  add

  1011121314151617181920
• -(_aclitem,aclitem)Internal and special-purpose10 – 20

  remove ACL item

  1011121314151617181920
• -(anymultirange,anymultirange)Pseudo-types14 – 20

  multirange minus

  1011121314151617181920
• -(anyrange,anyrange)Pseudo-types10 – 20

  range difference

  1011121314151617181920
• -(box,point)Geometric10 – 20

  subtract point from box (translate)

  1011121314151617181920
• -(circle,point)Geometric10 – 20

  subtract

  1011121314151617181920
• -(date,date)Date and time10 – 20

  subtract

  1011121314151617181920
• -(date,int4)Date and time10 – 20

  subtract

  1011121314151617181920
• -(date,interval)Date and time10 – 20

  subtract

  1011121314151617181920
• -(float4,float4)Numeric10 – 20

  subtract

  1011121314151617181920
• -(float4,float8)Numeric10 – 20

  subtract

  1011121314151617181920
• -(float8,float4)Numeric10 – 20

  subtract

  1011121314151617181920
• -(float8,float8)Numeric10 – 20

  subtract

  1011121314151617181920
• -(inet,inet)Network addresses10 – 20

  subtract

  1011121314151617181920
• -(inet,int8)Network addresses10 – 20

  subtract

  1011121314151617181920
• -(int2,int2)Numeric10 – 20

  subtract

  1011121314151617181920
• -(int2,int4)Numeric10 – 20

  subtract

  1011121314151617181920
• -(int2,int8)Numeric10 – 20

  subtract

  1011121314151617181920
• -(int4,int2)Numeric10 – 20

  subtract

  1011121314151617181920
• -(int4,int4)Numeric10 – 20

  subtract

  1011121314151617181920
• -(int4,int8)Numeric10 – 20

  subtract

  1011121314151617181920
• -(int8,int2)Numeric10 – 20

  subtract

  1011121314151617181920
• -(int8,int4)Numeric10 – 20

  subtract

  1011121314151617181920
• -(int8,int8)Numeric10 – 20

  subtract

  1011121314151617181920
• -(interval,interval)Date and time10 – 20

  subtract

  1011121314151617181920
• -(jsonb,_text)JSON10 – 20

  delete object fields

  1011121314151617181920
• -(jsonb,int4)JSON10 – 20

  delete array element

  1011121314151617181920
• -(jsonb,text)JSON10 – 20

  delete object field

  1011121314151617181920
• -(money,money)Numeric10 – 20

  subtract

  1011121314151617181920
• -(none,float4)Numeric10 – 20

  negate

  1011121314151617181920
• -(none,float8)Numeric10 – 20

  negate

  1011121314151617181920
• -(none,int2)Numeric10 – 20

  negate

  1011121314151617181920
• -(none,int4)Numeric10 – 20

  negate

  1011121314151617181920
• -(none,int8)Numeric10 – 20

  negate

  1011121314151617181920
• -(none,interval)Date and time10 – 20

  negate

  1011121314151617181920
• -(none,numeric)Numeric10 – 20

  negate

  1011121314151617181920
• -(numeric,numeric)Numeric10 – 20

  subtract

  1011121314151617181920
• -(path,point)Geometric10 – 20

  subtract (translate path)

  1011121314151617181920
• -(pg_lsn,numeric)Other built-in types14 – 20

  subtract

  1011121314151617181920
• -(pg_lsn,pg_lsn)Other built-in types10 – 20

  minus

  1011121314151617181920
• -(point,point)Geometric10 – 20

  subtract points (translate)

  1011121314151617181920
• -(time,interval)Date and time10 – 20

  subtract

  1011121314151617181920
• -(time,time)Date and time10 – 20

  subtract

  1011121314151617181920
• -(timestamp,interval)Date and time10 – 20

  subtract

  1011121314151617181920
• -(timestamp,timestamp)Date and time10 – 20

  subtract

  1011121314151617181920
• -(timestamptz,interval)Date and time10 – 20

  subtract

  1011121314151617181920
• -(timestamptz,timestamptz)Date and time10 – 20

  subtract

  1011121314151617181920
• -(timetz,interval)Date and time10 – 20

  subtract

  1011121314151617181920
• ->(json,int4)JSON10 – 20

  get json array element

  1011121314151617181920
• ->(json,text)JSON10 – 20

  get json object field

  1011121314151617181920
• ->(jsonb,int4)JSON10 – 20

  get jsonb array element

  1011121314151617181920
• ->(jsonb,text)JSON10 – 20

  get jsonb object field

  1011121314151617181920
• ->>(json,int4)JSON10 – 20

  get json array element as text

  1011121314151617181920
• ->>(json,text)JSON10 – 20

  get json object field as text

  1011121314151617181920
• ->>(jsonb,int4)JSON10 – 20

  get jsonb array element as text

  1011121314151617181920
• ->>(jsonb,text)JSON10 – 20

  get jsonb object field as text

  1011121314151617181920
• -|-(anymultirange,anymultirange)Pseudo-types14 – 20

  is adjacent to

  1011121314151617181920
• -|-(anymultirange,anyrange)Pseudo-types14 – 20

  is adjacent to

  1011121314151617181920
• -|-(anyrange,anymultirange)Pseudo-types14 – 20

  is adjacent to

  1011121314151617181920
• -|-(anyrange,anyrange)Pseudo-types10 – 20

  is adjacent to

  1011121314151617181920
• /(box,point)Geometric10 – 20

  divide box by point (scale)

  1011121314151617181920
• /(circle,point)Geometric10 – 20

  divide

  1011121314151617181920
• /(float4,float4)Numeric10 – 20

  divide

  1011121314151617181920
• /(float4,float8)Numeric10 – 20

  divide

  1011121314151617181920
• /(float8,float4)Numeric10 – 20

  divide

  1011121314151617181920
• /(float8,float8)Numeric10 – 20

  divide

  1011121314151617181920
• /(int2,int2)Numeric10 – 20

  divide

  1011121314151617181920
• /(int2,int4)Numeric10 – 20

  divide

  1011121314151617181920
• /(int2,int8)Numeric10 – 20

  divide

  1011121314151617181920
• /(int4,int2)Numeric10 – 20

  divide

  1011121314151617181920
• /(int4,int4)Numeric10 – 20

  divide

  1011121314151617181920
• /(int4,int8)Numeric10 – 20

  divide

  1011121314151617181920
• /(int8,int2)Numeric10 – 20

  divide

  1011121314151617181920
• /(int8,int4)Numeric10 – 20

  divide

  1011121314151617181920
• /(int8,int8)Numeric10 – 20

  divide

  1011121314151617181920
• /(interval,float8)Date and time10 – 20

  divide

  1011121314151617181920
• /(money,float4)Numeric10 – 20

  divide

  1011121314151617181920
• /(money,float8)Numeric10 – 20

  divide

  1011121314151617181920
• /(money,int2)Numeric10 – 20

  divide

  1011121314151617181920
• /(money,int4)Numeric10 – 20

  divide

  1011121314151617181920
• /(money,int8)Numeric10 – 20

  divide

  1011121314151617181920
• /(money,money)Numeric10 – 20

  divide

  1011121314151617181920
• /(numeric,numeric)Numeric10 – 20

  divide

  1011121314151617181920
• /(path,point)Geometric10 – 20

  divide (rotate/scale path)

  1011121314151617181920
• /(point,point)Geometric10 – 20

  divide points (scale/rotate)

  1011121314151617181920
• <(anyarray,anyarray)Pseudo-types10 – 20

  less than

  1011121314151617181920
• <(anyenum,anyenum)Pseudo-types10 – 20

  less than

  1011121314151617181920
• <(anymultirange,anymultirange)Pseudo-types14 – 20

  less than

  1011121314151617181920
• <(anyrange,anyrange)Pseudo-types10 – 20

  less than

  1011121314151617181920
• <(bit,bit)Bit strings10 – 20

  less than

  1011121314151617181920
• <(bool,bool)Boolean10 – 20

  less than

  1011121314151617181920
• <(box,box)Geometric10 – 20

  less than by area

  1011121314151617181920
• <(bpchar,bpchar)Character strings10 – 20

  less than

  1011121314151617181920
• <(bytea,bytea)Other built-in types10 – 20

  less than

  1011121314151617181920
• <(char,char)Character strings10 – 20

  less than

  1011121314151617181920
• <(circle,circle)Geometric10 – 20

  less than by area

  1011121314151617181920
• <(date,date)Date and time10 – 20

  less than

  1011121314151617181920
• <(date,timestamp)Date and time10 – 20

  less than

  1011121314151617181920
• <(date,timestamptz)Date and time10 – 20

  less than

  1011121314151617181920
• <(float4,float4)Numeric10 – 20

  less than

  1011121314151617181920
• <(float4,float8)Numeric10 – 20

  less than

  1011121314151617181920
• <(float8,float4)Numeric10 – 20

  less than

  1011121314151617181920
• <(float8,float8)Numeric10 – 20

  less than

  1011121314151617181920
• <(inet,inet)Network addresses10 – 20

  less than

  1011121314151617181920
• <(int2,int2)Numeric10 – 20

  less than

  1011121314151617181920
• <(int2,int4)Numeric10 – 20

  less than

  1011121314151617181920
• <(int2,int8)Numeric10 – 20

  less than

  1011121314151617181920
• <(int4,int2)Numeric10 – 20

  less than

  1011121314151617181920
• <(int4,int4)Numeric10 – 20

  less than

  1011121314151617181920
• <(int4,int8)Numeric10 – 20

  less than

  1011121314151617181920
• <(int8,int2)Numeric10 – 20

  less than

  1011121314151617181920
• <(int8,int4)Numeric10 – 20

  less than

  1011121314151617181920
• <(int8,int8)Numeric10 – 20

  less than

  1011121314151617181920
• <(interval,interval)Date and time10 – 20

  less than

  1011121314151617181920
• <(jsonb,jsonb)JSON10 – 20

  less than

  1011121314151617181920
• <(lseg,lseg)Geometric10 – 20

  less than by length

  1011121314151617181920
• <(macaddr,macaddr)Other built-in types10 – 20

  less than

  1011121314151617181920
• <(macaddr8,macaddr8)Other built-in types10 – 20

  less than

  1011121314151617181920
• <(money,money)Numeric10 – 20

  less than

  1011121314151617181920
• <(name,name)Character strings10 – 20

  less than

  1011121314151617181920
• <(name,text)Character strings12 – 20

  less than

  1011121314151617181920
• <(numeric,numeric)Numeric10 – 20

  less than

  1011121314151617181920
• <(oid,oid)Object and transaction identifiers10 – 20

  less than

  1011121314151617181920
• <(oidvector,oidvector)Internal and special-purpose10 – 20

  less than

  1011121314151617181920
• <(path,path)Geometric10 – 20

  less than

  1011121314151617181920
• <(pg_lsn,pg_lsn)Other built-in types10 – 20

  less than

  1011121314151617181920
• <(record,record)Pseudo-types10 – 20

  less than

  1011121314151617181920
• <(text,name)Character strings12 – 20

  less than

  1011121314151617181920
• <(text,text)Character strings10 – 20

  less than

  1011121314151617181920
• <(tid,tid)Object and transaction identifiers10 – 20

  less than

  1011121314151617181920
• <(time,time)Date and time10 – 20

  less than

  1011121314151617181920
• <(timestamp,date)Date and time10 – 20

  less than

  1011121314151617181920
• <(timestamp,timestamp)Date and time10 – 20

  less than

  1011121314151617181920
• <(timestamp,timestamptz)Date and time10 – 20

  less than

  1011121314151617181920
• <(timestamptz,date)Date and time10 – 20

  less than

  1011121314151617181920
• <(timestamptz,timestamp)Date and time10 – 20

  less than

  1011121314151617181920
• <(timestamptz,timestamptz)Date and time10 – 20

  less than

  1011121314151617181920
• <(timetz,timetz)Date and time10 – 20

  less than

  1011121314151617181920
• <(tsquery,tsquery)Text search10 – 20

  less than

  1011121314151617181920
• <(tsvector,tsvector)Text search10 – 20

  less than

  1011121314151617181920
• <(uuid,uuid)Other built-in types10 – 20

  less than

  1011121314151617181920
• <(varbit,varbit)Bit strings10 – 20

  less than

  1011121314151617181920
• <(xid8,xid8)Object and transaction identifiers13 – 20

  less than

  1011121314151617181920
• <->(box,box)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(box,lseg)Geometric13 – 20

  distance between

  1011121314151617181920
• <->(box,point)Geometric13 – 20

  distance between

  1011121314151617181920
• <->(circle,circle)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(circle,point)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(circle,polygon)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(line,line)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(line,lseg)Geometric13 – 20

  distance between

  1011121314151617181920
• <->(line,point)Geometric13 – 20

  distance between

  1011121314151617181920
• <->(lseg,box)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(lseg,line)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(lseg,lseg)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(lseg,point)Geometric13 – 20

  distance between

  1011121314151617181920
• <->(path,path)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(path,point)Geometric13 – 20

  distance between

  1011121314151617181920
• <->(point,box)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(point,circle)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(point,line)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(point,lseg)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(point,path)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(point,point)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(point,polygon)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(polygon,circle)Geometric13 – 20

  distance between

  1011121314151617181920
• <->(polygon,point)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(polygon,polygon)Geometric10 – 20

  distance between

  1011121314151617181920
• <->(tsquery,tsquery)Text search10 – 20

  phrase-concatenate

  1011121314151617181920
• <<(anymultirange,anymultirange)Pseudo-types14 – 20

  is left of

  1011121314151617181920
• <<(anymultirange,anyrange)Pseudo-types14 – 20

  is left of

  1011121314151617181920
• <<(anyrange,anymultirange)Pseudo-types14 – 20

  is left of

  1011121314151617181920
• <<(anyrange,anyrange)Pseudo-types10 – 20

  is left of

  1011121314151617181920
• <<(bit,int4)Bit strings10 – 20

  bitwise shift left

  1011121314151617181920
• <<(box,box)Geometric10 – 20

  is left of

  1011121314151617181920
• <<(circle,circle)Geometric10 – 20

  is left of

  1011121314151617181920
• <<(inet,inet)Network addresses10 – 20

  is subnet

  1011121314151617181920
• <<(int2,int4)Numeric10 – 20

  bitwise shift left

  1011121314151617181920
• <<(int4,int4)Numeric10 – 20

  bitwise shift left

  1011121314151617181920
• <<(int8,int4)Numeric10 – 20

  bitwise shift left

  1011121314151617181920
• <<(point,point)Geometric10 – 20

  is left of

  1011121314151617181920
• <<(polygon,polygon)Geometric10 – 20

  is left of

  1011121314151617181920
• <<=(inet,inet)Network addresses10 – 20

  is subnet or equal

  1011121314151617181920
• <<|(box,box)Geometric10 – 20

  is below

  1011121314151617181920
• <<|(circle,circle)Geometric10 – 20

  is below

  1011121314151617181920
• <<|(point,point)Geometric14 – 20

  is below

  1011121314151617181920
• <<|(polygon,polygon)Geometric10 – 20

  is below

  1011121314151617181920
• <=(anyarray,anyarray)Pseudo-types10 – 20

  less than or equal

  1011121314151617181920
• <=(anyenum,anyenum)Pseudo-types10 – 20

  less than or equal

  1011121314151617181920
• <=(anymultirange,anymultirange)Pseudo-types14 – 20

  less than or equal

  1011121314151617181920
• <=(anyrange,anyrange)Pseudo-types10 – 20

  less than or equal

  1011121314151617181920
• <=(bit,bit)Bit strings10 – 20

  less than or equal

  1011121314151617181920
• <=(bool,bool)Boolean10 – 20

  less than or equal

  1011121314151617181920
• <=(box,box)Geometric10 – 20

  less than or equal by area

  1011121314151617181920
• <=(bpchar,bpchar)Character strings10 – 20

  less than or equal

  1011121314151617181920
• <=(bytea,bytea)Other built-in types10 – 20

  less than or equal

  1011121314151617181920
• <=(char,char)Character strings10 – 20

  less than or equal

  1011121314151617181920
• <=(circle,circle)Geometric10 – 20

  less than or equal by area

  1011121314151617181920
• <=(date,date)Date and time10 – 20

  less than or equal

  1011121314151617181920
• <=(date,timestamp)Date and time10 – 20

  less than or equal

  1011121314151617181920
• <=(date,timestamptz)Date and time10 – 20

  less than or equal

  1011121314151617181920
• <=(float4,float4)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(float4,float8)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(float8,float4)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(float8,float8)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(inet,inet)Network addresses10 – 20

  less than or equal

  1011121314151617181920
• <=(int2,int2)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(int2,int4)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(int2,int8)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(int4,int2)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(int4,int4)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(int4,int8)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(int8,int2)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(int8,int4)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(int8,int8)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(interval,interval)Date and time10 – 20

  less than or equal

  1011121314151617181920
• <=(jsonb,jsonb)JSON10 – 20

  less than or equal

  1011121314151617181920
• <=(lseg,lseg)Geometric10 – 20

  less than or equal by length

  1011121314151617181920
• <=(macaddr,macaddr)Other built-in types10 – 20

  less than or equal

  1011121314151617181920
• <=(macaddr8,macaddr8)Other built-in types10 – 20

  less than or equal

  1011121314151617181920
• <=(money,money)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(name,name)Character strings10 – 20

  less than or equal

  1011121314151617181920
• <=(name,text)Character strings12 – 20

  less than or equal

  1011121314151617181920
• <=(numeric,numeric)Numeric10 – 20

  less than or equal

  1011121314151617181920
• <=(oid,oid)Object and transaction identifiers10 – 20

  less than or equal

  1011121314151617181920
• <=(oidvector,oidvector)Internal and special-purpose10 – 20

  less than or equal

  1011121314151617181920
• <=(path,path)Geometric10 – 20

  less than or equal

  1011121314151617181920
• <=(pg_lsn,pg_lsn)Other built-in types10 – 20

  less than or equal

  1011121314151617181920
• <=(record,record)Pseudo-types10 – 20

  less than or equal

  1011121314151617181920
• <=(text,name)Character strings12 – 20

  less than or equal

  1011121314151617181920
• <=(text,text)Character strings10 – 20

  less than or equal

  1011121314151617181920
• <=(tid,tid)Object and transaction identifiers10 – 20

  less than or equal

  1011121314151617181920
• <=(time,time)Date and time10 – 20

  less than or equal

  1011121314151617181920
• <=(timestamp,date)Date and time10 – 20

  less than or equal

  1011121314151617181920
• <=(timestamp,timestamp)Date and time10 – 20

  less than or equal

  1011121314151617181920
• <=(timestamp,timestamptz)Date and time10 – 20

  less than or equal

  1011121314151617181920
• <=(timestamptz,date)Date and time10 – 20

  less than or equal

  1011121314151617181920
• <=(timestamptz,timestamp)Date and time10 – 20

  less than or equal

  1011121314151617181920
• <=(timestamptz,timestamptz)Date and time10 – 20

  less than or equal

  1011121314151617181920
• <=(timetz,timetz)Date and time10 – 20

  less than or equal

  1011121314151617181920
• <=(tsquery,tsquery)Text search10 – 20

  less than or equal

  1011121314151617181920
• <=(tsvector,tsvector)Text search10 – 20

  less than or equal

  1011121314151617181920
• <=(uuid,uuid)Other built-in types10 – 20

  less than or equal

  1011121314151617181920
• <=(varbit,varbit)Bit strings10 – 20

  less than or equal

  1011121314151617181920
• <=(xid8,xid8)Object and transaction identifiers13 – 20

  less than or equal

  1011121314151617181920
• <>(anyarray,anyarray)Pseudo-types10 – 20

  not equal

  1011121314151617181920
• <>(anyenum,anyenum)Pseudo-types10 – 20

  not equal

  1011121314151617181920
• <>(anymultirange,anymultirange)Pseudo-types14 – 20

  not equal

  1011121314151617181920
• <>(anyrange,anyrange)Pseudo-types10 – 20

  not equal

  1011121314151617181920
• <>(bit,bit)Bit strings10 – 20

  not equal

  1011121314151617181920
• <>(bool,bool)Boolean10 – 20

  not equal

  1011121314151617181920
• <>(bpchar,bpchar)Character strings10 – 20

  not equal

  1011121314151617181920
• <>(bytea,bytea)Other built-in types10 – 20

  not equal

  1011121314151617181920
• <>(char,char)Character strings10 – 20

  not equal

  1011121314151617181920
• <>(circle,circle)Geometric10 – 20

  not equal by area

  1011121314151617181920
• <>(date,date)Date and time10 – 20

  not equal

  1011121314151617181920
• <>(date,timestamp)Date and time10 – 20

  not equal

  1011121314151617181920
• <>(date,timestamptz)Date and time10 – 20

  not equal

  1011121314151617181920
• <>(float4,float4)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(float4,float8)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(float8,float4)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(float8,float8)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(inet,inet)Network addresses10 – 20

  not equal

  1011121314151617181920
• <>(int2,int2)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(int2,int4)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(int2,int8)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(int4,int2)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(int4,int4)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(int4,int8)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(int8,int2)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(int8,int4)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(int8,int8)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(interval,interval)Date and time10 – 20

  not equal

  1011121314151617181920
• <>(jsonb,jsonb)JSON10 – 20

  not equal

  1011121314151617181920
• <>(lseg,lseg)Geometric10 – 20

  not equal

  1011121314151617181920
• <>(macaddr,macaddr)Other built-in types10 – 20

  not equal

  1011121314151617181920
• <>(macaddr8,macaddr8)Other built-in types10 – 20

  not equal

  1011121314151617181920
• <>(money,money)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(name,name)Character strings10 – 20

  not equal

  1011121314151617181920
• <>(name,text)Character strings12 – 20

  not equal

  1011121314151617181920
• <>(numeric,numeric)Numeric10 – 20

  not equal

  1011121314151617181920
• <>(oid,oid)Object and transaction identifiers10 – 20

  not equal

  1011121314151617181920
• <>(oidvector,oidvector)Internal and special-purpose10 – 20

  not equal

  1011121314151617181920
• <>(pg_lsn,pg_lsn)Other built-in types10 – 20

  not equal

  1011121314151617181920
• <>(point,point)Geometric10 – 20

  not equal

  1011121314151617181920
• <>(record,record)Pseudo-types10 – 20

  not equal

  1011121314151617181920
• <>(text,name)Character strings12 – 20

  not equal

  1011121314151617181920
• <>(text,text)Character strings10 – 20

  not equal

  1011121314151617181920
• <>(tid,tid)Object and transaction identifiers10 – 20

  not equal

  1011121314151617181920
• <>(time,time)Date and time10 – 20

  not equal

  1011121314151617181920
• <>(timestamp,date)Date and time10 – 20

  not equal

  1011121314151617181920
• <>(timestamp,timestamp)Date and time10 – 20

  not equal

  1011121314151617181920
• <>(timestamp,timestamptz)Date and time10 – 20

  not equal

  1011121314151617181920
• <>(timestamptz,date)Date and time10 – 20

  not equal

  1011121314151617181920
• <>(timestamptz,timestamp)Date and time10 – 20

  not equal

  1011121314151617181920
• <>(timestamptz,timestamptz)Date and time10 – 20

  not equal

  1011121314151617181920
• <>(timetz,timetz)Date and time10 – 20

  not equal

  1011121314151617181920
• <>(tsquery,tsquery)Text search10 – 20

  not equal

  1011121314151617181920
• <>(tsvector,tsvector)Text search10 – 20

  not equal

  1011121314151617181920
• <>(uuid,uuid)Other built-in types10 – 20

  not equal

  1011121314151617181920
• <>(varbit,varbit)Bit strings10 – 20

  not equal

  1011121314151617181920
• <>(xid,int4)Object and transaction identifiers10 – 20

  not equal

  1011121314151617181920
• <>(xid,xid)Object and transaction identifiers10 – 20

  not equal

  1011121314151617181920
• <>(xid8,xid8)Object and transaction identifiers13 – 20

  not equal

  1011121314151617181920
• <@(anyarray,anyarray)Pseudo-types10 – 20

  is contained by

  1011121314151617181920
• <@(anyelement,anymultirange)Pseudo-types14 – 20

  is contained by

  1011121314151617181920
• <@(anyelement,anyrange)Pseudo-types10 – 20

  is contained by

  1011121314151617181920
• <@(anymultirange,anymultirange)Pseudo-types14 – 20

  is contained by

  1011121314151617181920
• <@(anymultirange,anyrange)Pseudo-types14 – 20

  is contained by

  1011121314151617181920
• <@(anyrange,anymultirange)Pseudo-types14 – 20

  is contained by

  1011121314151617181920
• <@(anyrange,anyrange)Pseudo-types10 – 20

  is contained by

  1011121314151617181920
• <@(box,box)Geometric10 – 20

  is contained by

  1011121314151617181920
• <@(circle,circle)Geometric10 – 20

  is contained by

  1011121314151617181920
• <@(jsonb,jsonb)JSON10 – 20

  is contained by

  1011121314151617181920
• <@(lseg,box)Geometric10 – 20

  is contained by

  1011121314151617181920
• <@(lseg,line)Geometric10 – 20

  lseg on line

  1011121314151617181920
• <@(point,box)Geometric10 – 20

  point inside box

  1011121314151617181920
• <@(point,circle)Geometric10 – 20

  is contained by

  1011121314151617181920
• <@(point,line)Geometric10 – 20

  point on line

  1011121314151617181920
• <@(point,lseg)Geometric10 – 20

  is contained by

  1011121314151617181920
• <@(point,path)Geometric10 – 20

  point within closed path, or point on open path

  1011121314151617181920
• <@(point,polygon)Geometric10 – 20

  is contained by

  1011121314151617181920
• <@(polygon,polygon)Geometric10 – 20

  is contained by

  1011121314151617181920
• <@(tsquery,tsquery)Text search10 – 20

  is contained by

  1011121314151617181920
• <^(box,box)Geometric10 – 20

  is below (allows touching)

  1011121314151617181920
• <^(point,point)Geometric10 – 20

  deprecated, use <<| instead

  1011121314151617181920
• =(aclitem,aclitem)Other built-in types10 – 20

  equal

  1011121314151617181920
• =(anyarray,anyarray)Pseudo-types10 – 20

  equal

  1011121314151617181920
• =(anyenum,anyenum)Pseudo-types10 – 20

  equal

  1011121314151617181920
• =(anymultirange,anymultirange)Pseudo-types14 – 20

  equal

  1011121314151617181920
• =(anyrange,anyrange)Pseudo-types10 – 20

  equal

  1011121314151617181920
• =(bit,bit)Bit strings10 – 20

  equal

  1011121314151617181920
• =(bool,bool)Boolean10 – 20

  equal

  1011121314151617181920
• =(box,box)Geometric10 – 20

  equal by area

  1011121314151617181920
• =(bpchar,bpchar)Character strings10 – 20

  equal

  1011121314151617181920
• =(bytea,bytea)Other built-in types10 – 20

  equal

  1011121314151617181920
• =(char,char)Character strings10 – 20

  equal

  1011121314151617181920
• =(cid,cid)Object and transaction identifiers10 – 20

  equal

  1011121314151617181920
• =(circle,circle)Geometric10 – 20

  equal by area

  1011121314151617181920
• =(date,date)Date and time10 – 20

  equal

  1011121314151617181920
• =(date,timestamp)Date and time10 – 20

  equal

  1011121314151617181920
• =(date,timestamptz)Date and time10 – 20

  equal

  1011121314151617181920
• =(float4,float4)Numeric10 – 20

  equal

  1011121314151617181920
• =(float4,float8)Numeric10 – 20

  equal

  1011121314151617181920
• =(float8,float4)Numeric10 – 20

  equal

  1011121314151617181920
• =(float8,float8)Numeric10 – 20

  equal

  1011121314151617181920
• =(inet,inet)Network addresses10 – 20

  equal

  1011121314151617181920
• =(int2,int2)Numeric10 – 20

  equal

  1011121314151617181920
• =(int2,int4)Numeric10 – 20

  equal

  1011121314151617181920
• =(int2,int8)Numeric10 – 20

  equal

  1011121314151617181920
• =(int4,int2)Numeric10 – 20

  equal

  1011121314151617181920
• =(int4,int4)Numeric10 – 20

  equal

  1011121314151617181920
• =(int4,int8)Numeric10 – 20

  equal

  1011121314151617181920
• =(int8,int2)Numeric10 – 20

  equal

  1011121314151617181920
• =(int8,int4)Numeric10 – 20

  equal

  1011121314151617181920
• =(int8,int8)Numeric10 – 20

  equal

  1011121314151617181920
• =(interval,interval)Date and time10 – 20

  equal

  1011121314151617181920
• =(jsonb,jsonb)JSON10 – 20

  equal

  1011121314151617181920
• =(line,line)Geometric10 – 20

  equal

  1011121314151617181920
• =(lseg,lseg)Geometric10 – 20

  equal

  1011121314151617181920
• =(macaddr,macaddr)Other built-in types10 – 20

  equal

  1011121314151617181920
• =(macaddr8,macaddr8)Other built-in types10 – 20

  equal

  1011121314151617181920
• =(money,money)Numeric10 – 20

  equal

  1011121314151617181920
• =(name,name)Character strings10 – 20

  equal

  1011121314151617181920
• =(name,text)Character strings12 – 20

  equal

  1011121314151617181920
• =(numeric,numeric)Numeric10 – 20

  equal

  1011121314151617181920
• =(oid,oid)Object and transaction identifiers10 – 20

  equal

  1011121314151617181920
• =(oidvector,oidvector)Internal and special-purpose10 – 20

  equal

  1011121314151617181920
• =(path,path)Geometric10 – 20

  equal

  1011121314151617181920
• =(pg_lsn,pg_lsn)Other built-in types10 – 20

  equal

  1011121314151617181920
• =(record,record)Pseudo-types10 – 20

  equal

  1011121314151617181920
• =(text,name)Character strings12 – 20

  equal

  1011121314151617181920
• =(text,text)Character strings10 – 20

  equal

  1011121314151617181920
• =(tid,tid)Object and transaction identifiers10 – 20

  equal

  1011121314151617181920
• =(time,time)Date and time10 – 20

  equal

  1011121314151617181920
• =(timestamp,date)Date and time10 – 20

  equal

  1011121314151617181920
• =(timestamp,timestamp)Date and time10 – 20

  equal

  1011121314151617181920
• =(timestamp,timestamptz)Date and time10 – 20

  equal

  1011121314151617181920
• =(timestamptz,date)Date and time10 – 20

  equal

  1011121314151617181920
• =(timestamptz,timestamp)Date and time10 – 20

  equal

  1011121314151617181920
• =(timestamptz,timestamptz)Date and time10 – 20

  equal

  1011121314151617181920
• =(timetz,timetz)Date and time10 – 20

  equal

  1011121314151617181920
• =(tsquery,tsquery)Text search10 – 20

  equal

  1011121314151617181920
• =(tsvector,tsvector)Text search10 – 20

  equal

  1011121314151617181920
• =(uuid,uuid)Other built-in types10 – 20

  equal

  1011121314151617181920
• =(varbit,varbit)Bit strings10 – 20

  equal

  1011121314151617181920
• =(xid,int4)Object and transaction identifiers10 – 20

  equal

  1011121314151617181920
• =(xid,xid)Object and transaction identifiers10 – 20

  equal

  1011121314151617181920
• =(xid8,xid8)Object and transaction identifiers13 – 20

  equal

  1011121314151617181920
• >(anyarray,anyarray)Pseudo-types10 – 20

  greater than

  1011121314151617181920
• >(anyenum,anyenum)Pseudo-types10 – 20

  greater than

  1011121314151617181920
• >(anymultirange,anymultirange)Pseudo-types14 – 20

  greater than

  1011121314151617181920
• >(anyrange,anyrange)Pseudo-types10 – 20

  greater than

  1011121314151617181920
• >(bit,bit)Bit strings10 – 20

  greater than

  1011121314151617181920
• >(bool,bool)Boolean10 – 20

  greater than

  1011121314151617181920
• >(box,box)Geometric10 – 20

  greater than by area

  1011121314151617181920
• >(bpchar,bpchar)Character strings10 – 20

  greater than

  1011121314151617181920
• >(bytea,bytea)Other built-in types10 – 20

  greater than

  1011121314151617181920
• >(char,char)Character strings10 – 20

  greater than

  1011121314151617181920
• >(circle,circle)Geometric10 – 20

  greater than by area

  1011121314151617181920
• >(date,date)Date and time10 – 20

  greater than

  1011121314151617181920
• >(date,timestamp)Date and time10 – 20

  greater than

  1011121314151617181920
• >(date,timestamptz)Date and time10 – 20

  greater than

  1011121314151617181920
• >(float4,float4)Numeric10 – 20

  greater than

  1011121314151617181920
• >(float4,float8)Numeric10 – 20

  greater than

  1011121314151617181920
• >(float8,float4)Numeric10 – 20

  greater than

  1011121314151617181920
• >(float8,float8)Numeric10 – 20

  greater than

  1011121314151617181920
• >(inet,inet)Network addresses10 – 20

  greater than

  1011121314151617181920
• >(int2,int2)Numeric10 – 20

  greater than

  1011121314151617181920
• >(int2,int4)Numeric10 – 20

  greater than

  1011121314151617181920
• >(int2,int8)Numeric10 – 20

  greater than

  1011121314151617181920
• >(int4,int2)Numeric10 – 20

  greater than

  1011121314151617181920
• >(int4,int4)Numeric10 – 20

  greater than

  1011121314151617181920
• >(int4,int8)Numeric10 – 20

  greater than

  1011121314151617181920
• >(int8,int2)Numeric10 – 20

  greater than

  1011121314151617181920
• >(int8,int4)Numeric10 – 20

  greater than

  1011121314151617181920
• >(int8,int8)Numeric10 – 20

  greater than

  1011121314151617181920
• >(interval,interval)Date and time10 – 20

  greater than

  1011121314151617181920
• >(jsonb,jsonb)JSON10 – 20

  greater than

  1011121314151617181920
• >(lseg,lseg)Geometric10 – 20

  greater than by length

  1011121314151617181920
• >(macaddr,macaddr)Other built-in types10 – 20

  greater than

  1011121314151617181920
• >(macaddr8,macaddr8)Other built-in types10 – 20

  greater than

  1011121314151617181920
• >(money,money)Numeric10 – 20

  greater than

  1011121314151617181920
• >(name,name)Character strings10 – 20

  greater than

  1011121314151617181920
• >(name,text)Character strings12 – 20

  greater than

  1011121314151617181920
• >(numeric,numeric)Numeric10 – 20

  greater than

  1011121314151617181920
• >(oid,oid)Object and transaction identifiers10 – 20

  greater than

  1011121314151617181920
• >(oidvector,oidvector)Internal and special-purpose10 – 20

  greater than

  1011121314151617181920
• >(path,path)Geometric10 – 20

  greater than

  1011121314151617181920
• >(pg_lsn,pg_lsn)Other built-in types10 – 20

  greater than

  1011121314151617181920
• >(record,record)Pseudo-types10 – 20

  greater than

  1011121314151617181920
• >(text,name)Character strings12 – 20

  greater than

  1011121314151617181920
• >(text,text)Character strings10 – 20

  greater than

  1011121314151617181920
• >(tid,tid)Object and transaction identifiers10 – 20

  greater than

  1011121314151617181920
• >(time,time)Date and time10 – 20

  greater than

  1011121314151617181920
• >(timestamp,date)Date and time10 – 20

  greater than

  1011121314151617181920
• >(timestamp,timestamp)Date and time10 – 20

  greater than

  1011121314151617181920
• >(timestamp,timestamptz)Date and time10 – 20

  greater than

  1011121314151617181920
• >(timestamptz,date)Date and time10 – 20

  greater than

  1011121314151617181920
• >(timestamptz,timestamp)Date and time10 – 20

  greater than

  1011121314151617181920
• >(timestamptz,timestamptz)Date and time10 – 20

  greater than

  1011121314151617181920
• >(timetz,timetz)Date and time10 – 20

  greater than

  1011121314151617181920
• >(tsquery,tsquery)Text search10 – 20

  greater than

  1011121314151617181920
• >(tsvector,tsvector)Text search10 – 20

  greater than

  1011121314151617181920
• >(uuid,uuid)Other built-in types10 – 20

  greater than

  1011121314151617181920
• >(varbit,varbit)Bit strings10 – 20

  greater than

  1011121314151617181920
• >(xid8,xid8)Object and transaction identifiers13 – 20

  greater than

  1011121314151617181920
• >=(anyarray,anyarray)Pseudo-types10 – 20

  greater than or equal

  1011121314151617181920
• >=(anyenum,anyenum)Pseudo-types10 – 20

  greater than or equal

  1011121314151617181920
• >=(anymultirange,anymultirange)Pseudo-types14 – 20

  greater than or equal

  1011121314151617181920
• >=(anyrange,anyrange)Pseudo-types10 – 20

  greater than or equal

  1011121314151617181920
• >=(bit,bit)Bit strings10 – 20

  greater than or equal

  1011121314151617181920
• >=(bool,bool)Boolean10 – 20

  greater than or equal

  1011121314151617181920
• >=(box,box)Geometric10 – 20

  greater than or equal by area

  1011121314151617181920
• >=(bpchar,bpchar)Character strings10 – 20

  greater than or equal

  1011121314151617181920
• >=(bytea,bytea)Other built-in types10 – 20

  greater than or equal

  1011121314151617181920
• >=(char,char)Character strings10 – 20

  greater than or equal

  1011121314151617181920
• >=(circle,circle)Geometric10 – 20

  greater than or equal by area

  1011121314151617181920
• >=(date,date)Date and time10 – 20

  greater than or equal

  1011121314151617181920
• >=(date,timestamp)Date and time10 – 20

  greater than or equal

  1011121314151617181920
• >=(date,timestamptz)Date and time10 – 20

  greater than or equal

  1011121314151617181920
• >=(float4,float4)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(float4,float8)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(float8,float4)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(float8,float8)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(inet,inet)Network addresses10 – 20

  greater than or equal

  1011121314151617181920
• >=(int2,int2)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(int2,int4)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(int2,int8)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(int4,int2)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(int4,int4)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(int4,int8)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(int8,int2)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(int8,int4)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(int8,int8)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(interval,interval)Date and time10 – 20

  greater than or equal

  1011121314151617181920
• >=(jsonb,jsonb)JSON10 – 20

  greater than or equal

  1011121314151617181920
• >=(lseg,lseg)Geometric10 – 20

  greater than or equal by length

  1011121314151617181920
• >=(macaddr,macaddr)Other built-in types10 – 20

  greater than or equal

  1011121314151617181920
• >=(macaddr8,macaddr8)Other built-in types10 – 20

  greater than or equal

  1011121314151617181920
• >=(money,money)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(name,name)Character strings10 – 20

  greater than or equal

  1011121314151617181920
• >=(name,text)Character strings12 – 20

  greater than or equal

  1011121314151617181920
• >=(numeric,numeric)Numeric10 – 20

  greater than or equal

  1011121314151617181920
• >=(oid,oid)Object and transaction identifiers10 – 20

  greater than or equal

  1011121314151617181920
• >=(oidvector,oidvector)Internal and special-purpose10 – 20

  greater than or equal

  1011121314151617181920
• >=(path,path)Geometric10 – 20

  greater than or equal

  1011121314151617181920
• >=(pg_lsn,pg_lsn)Other built-in types10 – 20

  greater than or equal

  1011121314151617181920
• >=(record,record)Pseudo-types10 – 20

  greater than or equal

  1011121314151617181920
• >=(text,name)Character strings12 – 20

  greater than or equal

  1011121314151617181920
• >=(text,text)Character strings10 – 20

  greater than or equal

  1011121314151617181920
• >=(tid,tid)Object and transaction identifiers10 – 20

  greater than or equal

  1011121314151617181920
• >=(time,time)Date and time10 – 20

  greater than or equal

  1011121314151617181920
• >=(timestamp,date)Date and time10 – 20

  greater than or equal

  1011121314151617181920
• >=(timestamp,timestamp)Date and time10 – 20

  greater than or equal

  1011121314151617181920
• >=(timestamp,timestamptz)Date and time10 – 20

  greater than or equal

  1011121314151617181920
• >=(timestamptz,date)Date and time10 – 20

  greater than or equal

  1011121314151617181920
• >=(timestamptz,timestamp)Date and time10 – 20

  greater than or equal

  1011121314151617181920
• >=(timestamptz,timestamptz)Date and time10 – 20

  greater than or equal

  1011121314151617181920
• >=(timetz,timetz)Date and time10 – 20

  greater than or equal

  1011121314151617181920
• >=(tsquery,tsquery)Text search10 – 20

  greater than or equal

  1011121314151617181920
• >=(tsvector,tsvector)Text search10 – 20

  greater than or equal

  1011121314151617181920
• >=(uuid,uuid)Other built-in types10 – 20

  greater than or equal

  1011121314151617181920
• >=(varbit,varbit)Bit strings10 – 20

  greater than or equal

  1011121314151617181920
• >=(xid8,xid8)Object and transaction identifiers13 – 20

  greater than or equal

  1011121314151617181920
• >>(anymultirange,anymultirange)Pseudo-types14 – 20

  is right of

  1011121314151617181920
• >>(anymultirange,anyrange)Pseudo-types14 – 20

  is right of

  1011121314151617181920
• >>(anyrange,anymultirange)Pseudo-types14 – 20

  is right of

  1011121314151617181920
• >>(anyrange,anyrange)Pseudo-types10 – 20

  is right of

  1011121314151617181920
• >>(bit,int4)Bit strings10 – 20

  bitwise shift right

  1011121314151617181920
• >>(box,box)Geometric10 – 20

  is right of

  1011121314151617181920
• >>(circle,circle)Geometric10 – 20

  is right of

  1011121314151617181920
• >>(inet,inet)Network addresses10 – 20

  is supernet

  1011121314151617181920
• >>(int2,int4)Numeric10 – 20

  bitwise shift right

  1011121314151617181920
• >>(int4,int4)Numeric10 – 20

  bitwise shift right

  1011121314151617181920
• >>(int8,int4)Numeric10 – 20

  bitwise shift right

  1011121314151617181920
• >>(point,point)Geometric10 – 20

  is right of

  1011121314151617181920
• >>(polygon,polygon)Geometric10 – 20

  is right of

  1011121314151617181920
• >>=(inet,inet)Network addresses10 – 20

  is supernet or equal

  1011121314151617181920
• >^(box,box)Geometric10 – 20

  is above (allows touching)

  1011121314151617181920
• >^(point,point)Geometric10 – 20

  deprecated, use |>> instead

  1011121314151617181920
• ?#(box,box)Geometric10 – 20

  deprecated, use && instead

  1011121314151617181920
• ?#(line,box)Geometric10 – 20

  intersect

  1011121314151617181920
• ?#(line,line)Geometric10 – 20

  intersect

  1011121314151617181920
• ?#(lseg,box)Geometric10 – 20

  intersect

  1011121314151617181920
• ?#(lseg,line)Geometric10 – 20

  intersect

  1011121314151617181920
• ?#(lseg,lseg)Geometric10 – 20

  intersect

  1011121314151617181920
• ?#(path,path)Geometric10 – 20

  intersect

  1011121314151617181920
• ?&(jsonb,_text)JSON10 – 20

  all keys exist

  1011121314151617181920
• ?(jsonb,text)JSON10 – 20

  key exists

  1011121314151617181920
• ?-(none,line)Geometric10 – 20

  horizontal

  1011121314151617181920
• ?-(none,lseg)Geometric10 – 20

  horizontal

  1011121314151617181920
• ?-(point,point)Geometric10 – 20

  horizontally aligned

  1011121314151617181920
• ?-|(line,line)Geometric10 – 20

  perpendicular

  1011121314151617181920
• ?-|(lseg,lseg)Geometric10 – 20

  perpendicular

  1011121314151617181920
• ?|(jsonb,_text)JSON10 – 20

  any key exists

  1011121314151617181920
• ?|(none,line)Geometric10 – 20

  vertical

  1011121314151617181920
• ?|(none,lseg)Geometric10 – 20

  vertical

  1011121314151617181920
• ?|(point,point)Geometric10 – 20

  vertically aligned

  1011121314151617181920
• ?||(line,line)Geometric10 – 20

  parallel

  1011121314151617181920
• ?||(lseg,lseg)Geometric10 – 20

  parallel

  1011121314151617181920
• @(none,float4)Numeric10 – 20

  absolute value

  1011121314151617181920
• @(none,float8)Numeric10 – 20

  absolute value

  1011121314151617181920
• @(none,int2)Numeric10 – 20

  absolute value

  1011121314151617181920
• @(none,int4)Numeric10 – 20

  absolute value

  1011121314151617181920
• @(none,int8)Numeric10 – 20

  absolute value

  1011121314151617181920
• @(none,numeric)Numeric10 – 20

  absolute value

  1011121314151617181920
• @-@(none,lseg)Geometric10 – 20

  distance between endpoints

  1011121314151617181920
• @-@(none,path)Geometric10 – 20

  sum of path segment lengths

  1011121314151617181920
• @>(_aclitem,aclitem)Internal and special-purpose10 – 20

  contains

  1011121314151617181920
• @>(anyarray,anyarray)Pseudo-types10 – 20

  contains

  1011121314151617181920
• @>(anymultirange,anyelement)Pseudo-types14 – 20

  contains

  1011121314151617181920
• @>(anymultirange,anymultirange)Pseudo-types14 – 20

  contains

  1011121314151617181920
• @>(anymultirange,anyrange)Pseudo-types14 – 20

  contains

  1011121314151617181920
• @>(anyrange,anyelement)Pseudo-types10 – 20

  contains

  1011121314151617181920
• @>(anyrange,anymultirange)Pseudo-types14 – 20

  contains

  1011121314151617181920
• @>(anyrange,anyrange)Pseudo-types10 – 20

  contains

  1011121314151617181920
• @>(box,box)Geometric10 – 20

  contains

  1011121314151617181920
• @>(box,point)Geometric10 – 20

  contains

  1011121314151617181920
• @>(circle,circle)Geometric10 – 20

  contains

  1011121314151617181920
• @>(circle,point)Geometric10 – 20

  contains

  1011121314151617181920
• @>(jsonb,jsonb)JSON10 – 20

  contains

  1011121314151617181920
• @>(path,point)Geometric10 – 20

  contains

  1011121314151617181920
• @>(polygon,point)Geometric10 – 20

  contains

  1011121314151617181920
• @>(polygon,polygon)Geometric10 – 20

  contains

  1011121314151617181920
• @>(tsquery,tsquery)Text search10 – 20

  contains

  1011121314151617181920
• @?(jsonb,jsonpath)JSON12 – 20

  jsonpath exists

  1011121314151617181920
• @@(jsonb,jsonpath)JSON12 – 20

  jsonpath match

  1011121314151617181920
• @@(none,box)Geometric10 – 20

  center of

  1011121314151617181920
• @@(none,circle)Geometric10 – 20

  center of

  1011121314151617181920
• @@(none,lseg)Geometric10 – 20

  center of

  1011121314151617181920
• @@(none,polygon)Geometric10 – 20

  center of

  1011121314151617181920
• @@(text,text)Character strings10 – 20

  text search match

  1011121314151617181920
• @@(text,tsquery)Character strings10 – 20

  text search match

  1011121314151617181920
• @@(tsquery,tsvector)Text search10 – 20

  text search match

  1011121314151617181920
• @@(tsvector,tsquery)Text search10 – 20

  text search match

  1011121314151617181920
• @@@(tsquery,tsvector)Text search10 – 20

  deprecated, use @@ instead

  1011121314151617181920
• @@@(tsvector,tsquery)Text search10 – 20

  deprecated, use @@ instead

  1011121314151617181920
• ^(float8,float8)Numeric10 – 20

  exponentiation

  1011121314151617181920
• ^(numeric,numeric)Numeric10 – 20

  exponentiation

  1011121314151617181920
• ^@(text,text)Character strings11 – 20

  starts with

  1011121314151617181920
• |&>(box,box)Geometric10 – 20

  overlaps or is above

  1011121314151617181920
• |&>(circle,circle)Geometric10 – 20

  overlaps or is above

  1011121314151617181920
• |&>(polygon,polygon)Geometric10 – 20

  overlaps or is above

  1011121314151617181920
• |(bit,bit)Bit strings10 – 20

  bitwise or

  1011121314151617181920
• |(inet,inet)Network addresses10 – 20

  bitwise or

  1011121314151617181920
• |(int2,int2)Numeric10 – 20

  bitwise or

  1011121314151617181920
• |(int4,int4)Numeric10 – 20

  bitwise or

  1011121314151617181920
• |(int8,int8)Numeric10 – 20

  bitwise or

  1011121314151617181920
• |(macaddr,macaddr)Other built-in types10 – 20

  bitwise or

  1011121314151617181920
• |(macaddr8,macaddr8)Other built-in types10 – 20

  bitwise or

  1011121314151617181920
• |/(none,float8)Numeric10 – 20

  square root

  1011121314151617181920
• |>>(box,box)Geometric10 – 20

  is above

  1011121314151617181920
• |>>(circle,circle)Geometric10 – 20

  is above

  1011121314151617181920
• |>>(point,point)Geometric14 – 20

  is above

  1011121314151617181920
• |>>(polygon,polygon)Geometric10 – 20

  is above

  1011121314151617181920
• ||(anycompatible,anycompatiblearray)Pseudo-types14 – 20

  prepend element onto front of array

  1011121314151617181920
• ||(anycompatiblearray,anycompatible)Pseudo-types14 – 20

  append element onto end of array

  1011121314151617181920
• ||(anycompatiblearray,anycompatiblearray)Pseudo-types14 – 20

  concatenate

  1011121314151617181920
• ||(anynonarray,text)Pseudo-types10 – 20

  concatenate

  1011121314151617181920
• ||(bytea,bytea)Other built-in types10 – 20

  concatenate

  1011121314151617181920
• ||(jsonb,jsonb)JSON10 – 20

  concatenate

  1011121314151617181920
• ||(text,anynonarray)Character strings10 – 20

  concatenate

  1011121314151617181920
• ||(text,text)Character strings10 – 20

  concatenate

  1011121314151617181920
• ||(tsquery,tsquery)Text search10 – 20

  OR-concatenate

  1011121314151617181920
• ||(tsvector,tsvector)Text search10 – 20

  concatenate

  1011121314151617181920
• ||(varbit,varbit)Bit strings10 – 20

  concatenate

  1011121314151617181920
• ||/(none,float8)Numeric10 – 20

  cube root

  1011121314151617181920
• ~(bpchar,text)Character strings10 – 20

  matches regular expression, case-sensitive

  1011121314151617181920
• ~(name,text)Character strings10 – 20

  matches regular expression, case-sensitive

  1011121314151617181920
• ~(none,bit)Bit strings10 – 20

  bitwise not

  1011121314151617181920
• ~(none,inet)Network addresses10 – 20

  bitwise not

  1011121314151617181920
• ~(none,int2)Numeric10 – 20

  bitwise not

  1011121314151617181920
• ~(none,int4)Numeric10 – 20

  bitwise not

  1011121314151617181920
• ~(none,int8)Numeric10 – 20

  bitwise not

  1011121314151617181920
• ~(none,macaddr)Other built-in types10 – 20

  bitwise not

  1011121314151617181920
• ~(none,macaddr8)Other built-in types10 – 20

  bitwise not

  1011121314151617181920
• ~(text,text)Character strings10 – 20

  matches regular expression, case-sensitive

  1011121314151617181920
• ~*(bpchar,text)Character strings10 – 20

  matches regular expression, case-insensitive

  1011121314151617181920
• ~*(name,text)Character strings10 – 20

  matches regular expression, case-insensitive

  1011121314151617181920
• ~*(text,text)Character strings10 – 20

  matches regular expression, case-insensitive

  1011121314151617181920
• ~<=~(bpchar,bpchar)Character strings10 – 20

  less than or equal

  1011121314151617181920
• ~<=~(text,text)Character strings10 – 20

  less than or equal

  1011121314151617181920
• ~<~(bpchar,bpchar)Character strings10 – 20

  less than

  1011121314151617181920
• ~<~(text,text)Character strings10 – 20

  less than

  1011121314151617181920
• ~=(box,box)Geometric10 – 20

  same as

  1011121314151617181920
• ~=(circle,circle)Geometric10 – 20

  same as

  1011121314151617181920
• ~=(point,point)Geometric10 – 20

  same as

  1011121314151617181920
• ~=(polygon,polygon)Geometric10 – 20

  same as

  1011121314151617181920
• ~>=~(bpchar,bpchar)Character strings10 – 20

  greater than or equal

  1011121314151617181920
• ~>=~(text,text)Character strings10 – 20

  greater than or equal

  1011121314151617181920
• ~>~(bpchar,bpchar)Character strings10 – 20

  greater than

  1011121314151617181920
• ~>~(text,text)Character strings10 – 20

  greater than

  1011121314151617181920
• ~~(bpchar,text)Character strings10 – 20

  matches LIKE expression

  1011121314151617181920
• ~~(bytea,bytea)Other built-in types10 – 20

  matches LIKE expression

  1011121314151617181920
• ~~(name,text)Character strings10 – 20

  matches LIKE expression

  1011121314151617181920
• ~~(text,text)Character strings10 – 20

  matches LIKE expression

  1011121314151617181920
• ~~*(bpchar,text)Character strings10 – 20

  matches LIKE expression, case-insensitive

  1011121314151617181920
• ~~*(name,text)Character strings10 – 20

  matches LIKE expression, case-insensitive

  1011121314151617181920
• ~~*(text,text)Character strings10 – 20

  matches LIKE expression, case-insensitive

  1011121314151617181920