Functions / Version comparison
What changed?
Functions · PostgreSQL 8.1 → 8.2
Historical documentation for a PostgreSQL version that is no longer supported.
36 added · 0 removed · 16 changed · 0 coverage changes. These are changes between the pinned reference snapshots.
changedascii
--- 8.1 +++ 8.2 @@ -1 +1 @@ -ascii ( text ) → int +ascii ( string ) → int
changedinitcap
--- 8.1 +++ 8.2 @@ -1 +1 @@ -initcap ( text ) → text +initcap ( string ) → text
changedlength
--- 8.1 +++ 8.2 @@ -1,3 +1,2 @@ -length ( string text ) → int length ( string ) → int length ( object ) → double precision
changedmd5
--- 8.1 +++ 8.2 @@ -1,2 +1 @@ -md5 ( string text ) → text md5 ( string ) → text
changedquote_ident
--- 8.1 +++ 8.2 @@ -1 +1 @@ -quote_ident ( string text ) → text +quote_ident ( string ) → text
changedquote_literal
--- 8.1 +++ 8.2 @@ -1 +1 @@ -quote_literal ( string text ) → text +quote_literal ( string ) → text
changedto_ascii
--- 8.1 +++ 8.2 @@ -1 +1 @@ -to_ascii ( text [, encoding] ) → text +to_ascii ( string text [, encoding text] ) → text
addedclock_timestamp
--- 8.1 +++ 8.2 @@ -0,0 +1,2 @@ +clock_timestamp ( ) → timestamp with time zone +clock_timestamp()
changedcurrent_time
--- 8.1 +++ 8.2 @@ -1,2 +1,2 @@ current_time → time with time zone -CURRENT_TIME (precision) +CURRENT_TIME(precision)
changedcurrent_timestamp
--- 8.1 +++ 8.2 @@ -1,2 +1,2 @@ current_timestamp → timestamp with time zone -CURRENT_TIMESTAMP (precision) LOCALTIME LOCALTIMESTAMP +CURRENT_TIMESTAMP(precision) LOCALTIME LOCALTIMESTAMP
addedjustify_interval
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +justify_interval ( interval ) → interval
changedlocaltime
--- 8.1 +++ 8.2 @@ -1,2 +1,2 @@ localtime → time -LOCALTIME (precision) +LOCALTIME(precision)
changedlocaltimestamp
--- 8.1 +++ 8.2 @@ -1,2 +1,2 @@ localtimestamp → timestamp -LOCALTIMESTAMP (precision) +LOCALTIMESTAMP(precision)
changednow
--- 8.1 +++ 8.2 @@ -1 +1,2 @@ now ( ) → timestamp with time zone +now()
addedpg_sleep
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +pg_sleep(seconds)
addedstatement_timestamp
--- 8.1 +++ 8.2 @@ -0,0 +1,2 @@ +statement_timestamp ( ) → timestamp with time zone +statement_timestamp()
changedtimeofday
--- 8.1 +++ 8.2 @@ -1 +1,2 @@ timeofday ( ) → text +timeofday()
addedtransaction_timestamp
--- 8.1 +++ 8.2 @@ -0,0 +1,2 @@ +transaction_timestamp ( ) → timestamp with time zone +transaction_timestamp()
changedabbrev
--- 8.1 +++ 8.2 @@ -1 +1,2 @@ abbrev ( inet ) → text +abbrev ( cidr ) → text
changedset_masklen
--- 8.1 +++ 8.2 @@ -1 +1,2 @@ set_masklen ( inet, int ) → inet +set_masklen ( cidr, int ) → cidr
changedlastval
--- 8.1 +++ 8.2 @@ -1 +0,0 @@ -lastval ( ) → bigint
addedcorr
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +corr ( Y, X ) → double precision
addedcovar_pop
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +covar_pop ( Y, X ) → double precision
addedcovar_samp
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +covar_samp ( Y, X ) → double precision
addedregr_avgx
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +regr_avgx ( Y, X ) → double precision
addedregr_avgy
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +regr_avgy ( Y, X ) → double precision
addedregr_count
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +regr_count ( Y, X ) → bigint
addedregr_intercept
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +regr_intercept ( Y, X ) → double precision
addedregr_r2
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +regr_r2 ( Y, X ) → double precision
addedregr_slope
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +regr_slope ( Y, X ) → double precision
addedregr_sxx
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +regr_sxx ( Y, X ) → double precision
addedregr_sxy
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +regr_sxy ( Y, X ) → double precision
addedregr_syy
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +regr_syy ( Y, X ) → double precision
addedstddev_pop
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +stddev_pop ( expression ) → double precision for floating-point arguments, otherwise numeric
addedstddev_samp
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +stddev_samp ( expression ) → double precision for floating-point arguments, otherwise numeric
addedvar_pop
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +var_pop ( expression ) → double precision for floating-point arguments, otherwise numeric
addedvar_samp
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +var_samp ( expression ) → double precision for floating-point arguments, otherwise numeric
addedpg_is_other_temp_schema
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +pg_is_other_temp_schema ( oid ) → boolean
addedpg_my_temp_schema
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +pg_my_temp_schema ( ) → oid
addedshobj_description
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +shobj_description ( object_oid, catalog_name ) → text
addedpg_advisory_lock
--- 8.1 +++ 8.2 @@ -0,0 +1,2 @@ +pg_advisory_lock ( key bigint ) → void +pg_advisory_lock ( key1 int, key2 int ) → void
addedpg_advisory_lock_shared
--- 8.1 +++ 8.2 @@ -0,0 +1,2 @@ +pg_advisory_lock_shared ( key bigint ) → void +pg_advisory_lock_shared ( key1 int, key2 int ) → void
addedpg_advisory_unlock
--- 8.1 +++ 8.2 @@ -0,0 +1,2 @@ +pg_advisory_unlock ( key bigint ) → boolean +pg_advisory_unlock ( key1 int, key2 int ) → boolean
addedpg_advisory_unlock_all
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +pg_advisory_unlock_all ( ) → void
addedpg_advisory_unlock_shared
--- 8.1 +++ 8.2 @@ -0,0 +1,2 @@ +pg_advisory_unlock_shared ( key bigint ) → boolean +pg_advisory_unlock_shared ( key1 int, key2 int ) → boolean
addedpg_current_xlog_insert_location
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +pg_current_xlog_insert_location ( ) → text
addedpg_current_xlog_location
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +pg_current_xlog_location ( ) → text
addedpg_switch_xlog
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +pg_switch_xlog ( ) → text
addedpg_try_advisory_lock
--- 8.1 +++ 8.2 @@ -0,0 +1,2 @@ +pg_try_advisory_lock ( key bigint ) → boolean +pg_try_advisory_lock ( key1 int, key2 int ) → boolean
addedpg_try_advisory_lock_shared
--- 8.1 +++ 8.2 @@ -0,0 +1,2 @@ +pg_try_advisory_lock_shared ( key bigint ) → boolean +pg_try_advisory_lock_shared ( key1 int, key2 int ) → boolean
addedpg_xlogfile_name
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +pg_xlogfile_name ( location text ) → text
addedpg_xlogfile_name_offset
--- 8.1 +++ 8.2 @@ -0,0 +1 @@ +pg_xlogfile_name_offset ( location text ) → text, integer