↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Operators / Changes

Operators changes

PostgreSQL 13 → 14

239 entries with a recorded attribute or presence change.

EntryChange
=(bpchar,bpchar)changed
=(char,char)changed
=(name,name)changed
=(text,text)changed
<(date,date)changed
<(date,timestamp)changed
<(date,timestamptz)changed
<(interval,interval)changed
<(time,time)changed
<(timestamp,date)changed
<(timestamp,timestamp)changed
<(timestamp,timestamptz)changed
<(timestamptz,date)changed
<(timestamptz,timestamp)changed
<(timestamptz,timestamptz)changed
<(timetz,timetz)changed
<=(date,date)changed
<=(date,timestamp)changed
<=(date,timestamptz)changed
<=(interval,interval)changed
<=(time,time)changed
<=(timestamp,date)changed
<=(timestamp,timestamp)changed
<=(timestamp,timestamptz)changed
<=(timestamptz,date)changed
<=(timestamptz,timestamp)changed
<=(timestamptz,timestamptz)changed
<=(timetz,timetz)changed
=(date,date)changed
=(date,timestamp)changed
=(date,timestamptz)changed
=(interval,interval)changed
=(time,time)changed
=(timestamp,date)changed
=(timestamp,timestamp)changed
=(timestamp,timestamptz)changed
=(timestamptz,date)changed
=(timestamptz,timestamp)changed
=(timestamptz,timestamptz)changed
=(timetz,timetz)changed
>(date,date)changed
>(date,timestamp)changed
>(date,timestamptz)changed
>(interval,interval)changed
>(time,time)changed
>(timestamp,date)changed
>(timestamp,timestamp)changed
>(timestamp,timestamptz)changed
>(timestamptz,date)changed
>(timestamptz,timestamp)changed
>(timestamptz,timestamptz)changed
>(timetz,timetz)changed
>=(date,date)changed
>=(date,timestamp)changed
>=(date,timestamptz)changed
>=(interval,interval)changed
>=(time,time)changed
>=(timestamp,date)changed
>=(timestamp,timestamp)changed
>=(timestamp,timestamptz)changed
>=(timestamptz,date)changed
>=(timestamptz,timestamp)changed
>=(timestamptz,timestamptz)changed
>=(timetz,timetz)changed
<<|(point,point)added
<^(point,point)changed
>^(point,point)changed
@(box,box)removed
@(circle,circle)removed
@(lseg,box)removed
@(lseg,line)removed
@(point,box)removed
@(point,circle)removed
@(point,line)removed
@(point,lseg)removed
@(point,path)removed
@(point,polygon)removed
@(polygon,polygon)removed
|>>(point,point)added
~(box,box)removed
~(circle,circle)removed
~(circle,point)removed
~(path,point)removed
~(polygon,point)removed
~(polygon,polygon)removed
~(_aclitem,aclitem)removed
<(inet,inet)changed
<=(inet,inet)changed
=(inet,inet)changed
>(inet,inet)changed
>=(inet,inet)changed
!!(none,int8)removed
!(int8,none)removed
+(numeric,pg_lsn)added
<(float4,float4)changed
<(float4,float8)changed
<(float8,float4)changed
<(float8,float8)changed
<(int2,int2)changed
<(int2,int4)changed
<(int2,int8)changed
<(int4,int2)changed
<(int4,int4)changed
<(int4,int8)changed
<(int8,int2)changed
<(int8,int4)changed
<(int8,int8)changed
<(numeric,numeric)changed
<=(float4,float4)changed
<=(float4,float8)changed
<=(float8,float4)changed
<=(float8,float8)changed
<=(int2,int2)changed
<=(int2,int4)changed
<=(int2,int8)changed
<=(int4,int2)changed
<=(int4,int4)changed
<=(int4,int8)changed
<=(int8,int2)changed
<=(int8,int4)changed
<=(int8,int8)changed
<=(numeric,numeric)changed
=(float4,float4)changed
=(float4,float8)changed
=(float8,float4)changed
=(float8,float8)changed
=(int2,int2)changed
=(int2,int4)changed
=(int2,int8)changed
=(int4,int2)changed
=(int4,int4)changed
=(int4,int8)changed
=(int8,int2)changed
=(int8,int4)changed
=(int8,int8)changed
=(numeric,numeric)changed
>(float4,float4)changed
>(float4,float8)changed
>(float8,float4)changed
>(float8,float8)changed
>(int2,int2)changed
>(int2,int4)changed
>(int2,int8)changed
>(int4,int2)changed
>(int4,int4)changed
>(int4,int8)changed
>(int8,int2)changed
>(int8,int4)changed
>(int8,int8)changed
>(numeric,numeric)changed
>=(float4,float4)changed
>=(float4,float8)changed
>=(float8,float4)changed
>=(float8,float8)changed
>=(int2,int2)changed
>=(int2,int4)changed
>=(int2,int8)changed
>=(int4,int2)changed
>=(int4,int4)changed
>=(int4,int8)changed
>=(int8,int2)changed
>=(int8,int4)changed
>=(int8,int8)changed
>=(numeric,numeric)changed
<(oid,oid)changed
<(tid,tid)changed
<=(oid,oid)changed
<=(tid,tid)changed
=(oid,oid)changed
=(tid,tid)changed
>(oid,oid)changed
>(tid,tid)changed
>=(oid,oid)changed
>=(tid,tid)changed
+(pg_lsn,numeric)added
-(pg_lsn,numeric)added
<(macaddr,macaddr)changed
<(macaddr8,macaddr8)changed
<(pg_lsn,pg_lsn)changed
<(uuid,uuid)changed
<=(macaddr,macaddr)changed
<=(macaddr8,macaddr8)changed
<=(pg_lsn,pg_lsn)changed
<=(uuid,uuid)changed
=(bytea,bytea)changed
=(macaddr,macaddr)changed
=(macaddr8,macaddr8)changed
=(pg_lsn,pg_lsn)changed
=(uuid,uuid)changed
>(macaddr,macaddr)changed
>(macaddr8,macaddr8)changed
>(pg_lsn,pg_lsn)changed
>(uuid,uuid)changed
>=(macaddr,macaddr)changed
>=(macaddr8,macaddr8)changed
>=(pg_lsn,pg_lsn)changed
>=(uuid,uuid)changed
&&(anymultirange,anymultirange)added
&&(anymultirange,anyrange)added
&&(anyrange,anymultirange)added
&<(anymultirange,anymultirange)added
&<(anymultirange,anyrange)added
&<(anyrange,anymultirange)added
&>(anymultirange,anymultirange)added
&>(anymultirange,anyrange)added
&>(anyrange,anymultirange)added
*(anymultirange,anymultirange)added
+(anymultirange,anymultirange)added
-(anymultirange,anymultirange)added
-|-(anymultirange,anymultirange)added
-|-(anymultirange,anyrange)added
-|-(anyrange,anymultirange)added
<(anymultirange,anymultirange)added
<<(anymultirange,anymultirange)added
<<(anymultirange,anyrange)added
<<(anyrange,anymultirange)added
<=(anymultirange,anymultirange)added
<>(anymultirange,anymultirange)added
<@(anyelement,anymultirange)added
<@(anymultirange,anymultirange)added
<@(anymultirange,anyrange)added
<@(anyrange,anymultirange)added
=(anymultirange,anymultirange)added
=(record,record)changed
>(anymultirange,anymultirange)added
>=(anymultirange,anymultirange)added
>>(anymultirange,anymultirange)added
>>(anymultirange,anyrange)added
>>(anyrange,anymultirange)added
@>(anymultirange,anyelement)added
@>(anymultirange,anymultirange)added
@>(anymultirange,anyrange)added
@>(anyrange,anymultirange)added
||(anyarray,anyarray)removed
||(anyarray,anyelement)removed
||(anycompatible,anycompatiblearray)added
||(anycompatiblearray,anycompatible)added
||(anycompatiblearray,anycompatiblearray)added
||(anyelement,anyarray)removed

Changes concern the sampled builds. Source fingerprints and build metadata are excluded. Back to Operators