Functions / Version comparison
What changed?
Functions · PostgreSQL 7.1 → 7.2
Historical documentation for a PostgreSQL version that is no longer supported.
21 added · 0 removed · 15 changed · 0 coverage changes. These are changes between the pinned reference snapshots.
addedsign
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +sign ( numeric ) → numeric
addedbit_length
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +bit_length ( string ) → integer
changedbtrim
--- 7.1 +++ 7.2 @@ -1 +1,2 @@ btrim ( string text, trim text ) → text +btrim ( string bytea, trim bytea ) → bytea
changedlength
--- 7.1 +++ 7.2 @@ -1 +1,2 @@ +length ( string ) → integer length ( object ) → double precision
addedpg_client_encoding
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +pg_client_encoding ( ) → name
changedsubstring
--- 7.1 +++ 7.2 @@ -1 +1,2 @@ substring ( string [from integer] [for integer] ) → text +substring ( string [from integer] [for integer] ) → bytea
changedtrim
--- 7.1 +++ 7.2 @@ -1 +1,2 @@ trim ( [leading | trailing | both] [characters] from string ) → text +trim ( [both] characters from string ) → bytea
addedconvert
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +convert ( string text, [src_encoding name,] dest_encoding name ) → text
addeddecode
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +decode ( string text, type text ) → bytea
addedencode
--- 7.1 +++ 7.2 @@ -0,0 +1,2 @@ +encode ( data bytea, type text ) → text +encode ( string bytea, type text ) → text
changedto_char
--- 7.1 +++ 7.2 @@ -1,4 +1,5 @@ to_char ( timestamp, text ) → text +to_char ( interval, text ) → text to_char ( int, text ) → text to_char ( double precision, text ) → text to_char ( numeric, text ) → text
addedcurrent_date
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +current_date → date
addedcurrent_time
--- 7.1 +++ 7.2 @@ -0,0 +1,2 @@ +current_time → time +CURRENT_TIME ( precision )
changedcurrent_timestamp
--- 7.1 +++ 7.2 @@ -0,0 +1,2 @@ +current_timestamp → timestamp +CURRENT_TIMESTAMP ( precision )
changednpoint
--- 7.1 +++ 7.2 @@ -1 +1 @@ -npoint ( path ) → int4 +npoint ( path ) → integer
addedset_masklen
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +set_masklen ( inet,integer ) → inet
addedcurrval
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +currval ( text ) → bigint
addednextval
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +nextval ( text ) → bigint
addedsetval
--- 7.1 +++ 7.2 @@ -0,0 +1,2 @@ +setval ( text,bigint ) → bigint +setval ( text,bigint,boolean ) → bigint
changedcount
--- 7.1 +++ 7.2 @@ -1,2 +1,2 @@ -COUNT ( * ) -COUNT ( expression ) +count ( * ) +count ( expression )
changedmax
--- 7.1 +++ 7.2 @@ -1 +1 @@ -MAX ( expression ) +max ( expression )
changedmin
--- 7.1 +++ 7.2 @@ -1 +1 @@ -MIN ( expression ) +min ( expression )
changedstddev
--- 7.1 +++ 7.2 @@ -1 +1 @@ -STDDEV ( expression ) +stddev ( expression )
changedsum
--- 7.1 +++ 7.2 @@ -1 +1 @@ -SUM ( expression ) +sum ( expression )
changedvariance
--- 7.1 +++ 7.2 @@ -1 +1 @@ -VARIANCE ( expression ) +variance ( expression )
addedcol_description
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +col_description ( tableOID, columnnumber ) → text
changedcurrent_user
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +current_user → name
addedhas_table_privilege
--- 7.1 +++ 7.2 @@ -0,0 +1,2 @@ +has_table_privilege ( user, table, access ) → boolean +has_table_privilege ( table, access ) → boolean
addedobj_description
--- 7.1 +++ 7.2 @@ -0,0 +1,2 @@ +obj_description ( objectOID, tablename ) → text +obj_description ( objectOID ) → text
addedpg_get_indexdef
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +pg_get_indexdef ( indexOID ) → text
addedpg_get_ruledef
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +pg_get_ruledef ( rulename ) → text
addedpg_get_userbyid
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +pg_get_userbyid ( userid ) → name
addedpg_get_viewdef
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +pg_get_viewdef ( viewname ) → text
changedsession_user
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +session_user → name
addeduser
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +user → name
addedversion
--- 7.1 +++ 7.2 @@ -0,0 +1 @@ +version → text