Functions / Version comparison
What changed?
Functions · PostgreSQL 7.2 → 7.3
Historical documentation for a PostgreSQL version that is no longer supported.
28 added · 2 removed · 29 changed · 0 coverage changes. These are changes between the pinned reference snapshots.
changedceil
--- 7.2 +++ 7.3 @@ -1 +1 @@ -ceil ( numeric ) → numeric +ceil ( dp or numeric ) → (same as input)
changedexp
--- 7.2 +++ 7.3 @@ -1 +1 @@ -exp ( dp ) → dp +exp ( dp or numeric ) → (same as input)
changedfloor
--- 7.2 +++ 7.3 @@ -1 +1 @@ -floor ( numeric ) → numeric +floor ( dp or numeric ) → (same as input)
changedln
--- 7.2 +++ 7.3 @@ -1 +1 @@ -ln ( dp ) → dp +ln ( dp or numeric ) → (same as input)
changedlog
--- 7.2 +++ 7.3 @@ -1,2 +1,2 @@ -log ( dp ) → dp +log ( dp or numeric ) → (same as input) log ( b numeric, x numeric ) → numeric
changedpow
--- 7.2 +++ 7.3 @@ -1 +1,2 @@ -pow ( e dp, n dp ) → dp +pow ( x dp, e dp ) → dp +pow ( x numeric, e numeric ) → numeric
changedround
--- 7.2 +++ 7.3 @@ -1,2 +1,2 @@ -round ( dp ) → dp +round ( dp or numeric ) → (same as input) round ( v numeric, s integer ) → numeric
changedsign
--- 7.2 +++ 7.3 @@ -1 +1 @@ -sign ( numeric ) → numeric +sign ( dp or numeric ) → (same as input)
changedsqrt
--- 7.2 +++ 7.3 @@ -1 +1 @@ -sqrt ( dp ) → dp +sqrt ( dp or numeric ) → (same as input)
changedtrunc
--- 7.2 +++ 7.3 @@ -1,3 +1,3 @@ -trunc ( dp ) → dp -trunc ( numeric, s integer ) → numeric +trunc ( dp or numeric ) → (same as input) +trunc ( v numeric, s integer ) → numeric trunc ( macaddr ) → macaddr
changedbtrim
--- 7.2 +++ 7.3 @@ -1,2 +1,2 @@ btrim ( string text, trim text ) → text -btrim ( string bytea, trim bytea ) → bytea +btrim ( string bytea trim bytea ) → bytea
changedltrim
--- 7.2 +++ 7.3 @@ -1 +1 @@ -ltrim ( string text, trim text ) → text +ltrim ( string text, text text ) → text
addedoverlay
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +overlay ( string placing string from integer [for integer] ) → text
addedquote_ident
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +quote_ident ( string text ) → text
addedquote_literal
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +quote_literal ( string text ) → text
addedreplace
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +replace ( string text, from text, to text ) → text
addedsplit_part
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +split_part ( string text, delimiter text, column integer ) → text
changedstrpos
--- 7.2 +++ 7.3 @@ -1 +1 @@ -strpos ( string, substring ) → text +strpos ( string, substring ) → int
changedsubstring
--- 7.2 +++ 7.3 @@ -1,2 +1,4 @@ substring ( string [from integer] [for integer] ) → text +substring ( string from pattern ) → text +substring ( string from pattern for escape ) → text substring ( string [from integer] [for integer] ) → bytea
addedto_hex
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +to_hex ( number integer or bigint ) → text
changedconvert
--- 7.2 +++ 7.3 @@ -1 +1,2 @@ +convert ( string using conversion_name ) → text convert ( string text, [src_encoding name,] dest_encoding name ) → text
addedget_bit
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +get_bit ( string, offset ) → integer
addedget_byte
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +get_byte ( string, offset ) → integer
addedset_bit
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +set_bit ( string, offset, newvalue ) → bytea
addedset_byte
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +set_byte ( string, offset, newvalue ) → bytea
changedcurrent_time
--- 7.2 +++ 7.3 @@ -1,2 +1,2 @@ -current_time → time +current_time → time with time zone CURRENT_TIME ( precision )
changedcurrent_timestamp
--- 7.2 +++ 7.3 @@ -1,2 +1,2 @@ -current_timestamp → timestamp -CURRENT_TIMESTAMP ( precision ) +current_timestamp → timestamp with time zone +CURRENT_TIMESTAMP ( precision ) LOCALTIME LOCALTIMESTAMP
addedlocaltime
--- 7.2 +++ 7.3 @@ -0,0 +1,2 @@ +localtime → time +LOCALTIME ( precision )
addedlocaltimestamp
--- 7.2 +++ 7.3 @@ -0,0 +1,2 @@ +localtimestamp → timestamp +LOCALTIMESTAMP ( precision )
changednow
--- 7.2 +++ 7.3 @@ -1 +1 @@ -now ( ) → timestamp +now ( ) → timestamp with time zone
removedtimestamp
--- 7.2 +++ 7.3 @@ -1,2 +0,0 @@ -timestamp ( date ) → timestamp -timestamp ( date, time ) → timestamp
removednpoint
--- 7.2 +++ 7.3 @@ -1 +0,0 @@ -npoint ( path ) → integer
addednpoints
--- 7.2 +++ 7.3 @@ -0,0 +1,2 @@ +npoints ( path ) → integer +npoints ( polygon ) → integer
changedCOALESCE
--- 7.2 +++ 7.3 @@ -1 +1 @@ -COALESCE(value[, ...]) +COALESCE(value [, ...])
changedavg
--- 7.2 +++ 7.3 @@ -1 +1 @@ -AVG ( expression ) +avg ( expression ) → numeric for any integer type argument, double precision for a floating-point argument, otherwise the same as the argument data type
changedcount
--- 7.2 +++ 7.3 @@ -1,2 +1,2 @@ -count ( * ) -count ( expression ) +count ( * ) → bigint +count ( expression ) → bigint
changedmax
--- 7.2 +++ 7.3 @@ -1 +1 @@ -max ( expression ) +max ( expression ) → same as argument type
changedmin
--- 7.2 +++ 7.3 @@ -1 +1 @@ -min ( expression ) +min ( expression ) → same as argument type
changedstddev
--- 7.2 +++ 7.3 @@ -1 +1 @@ -stddev ( expression ) +stddev ( expression ) → double precision for floating-point arguments, otherwise numeric
changedsum
--- 7.2 +++ 7.3 @@ -1 +1 @@ -sum ( expression ) +sum ( expression ) → bigint for smallint or integer arguments, numeric for bigint arguments, double precision for floating-point arguments, otherwise the same as the argument data type
changedvariance
--- 7.2 +++ 7.3 @@ -1 +1 @@ -variance ( expression ) +variance ( expression ) → double precision for floating-point arguments, otherwise numeric
addedcurrent_database
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +current_database ( ) → name
addedcurrent_schema
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +current_schema ( ) → name
addedcurrent_schemas
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +current_schemas ( boolean ) → name[]
addedhas_database_privilege
--- 7.2 +++ 7.3 @@ -0,0 +1,2 @@ +has_database_privilege ( user, database, access ) → boolean +has_database_privilege ( database, access ) → boolean
addedhas_function_privilege
--- 7.2 +++ 7.3 @@ -0,0 +1,2 @@ +has_function_privilege ( user, function, access ) → boolean +has_function_privilege ( function, access ) → boolean
addedhas_language_privilege
--- 7.2 +++ 7.3 @@ -0,0 +1,2 @@ +has_language_privilege ( user, language, access ) → boolean +has_language_privilege ( language, access ) → boolean
addedhas_schema_privilege
--- 7.2 +++ 7.3 @@ -0,0 +1,2 @@ +has_schema_privilege ( user, schema, access ) → boolean +has_schema_privilege ( schema, access ) → boolean
addedpg_function_is_visible
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +pg_function_is_visible ( functionOID ) → boolean
addedpg_get_constraintdef
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +pg_get_constraintdef ( constraintOID ) → text
changedpg_get_ruledef
--- 7.2 +++ 7.3 @@ -1 +1 @@ -pg_get_ruledef ( rulename ) → text +pg_get_ruledef ( ruleOID ) → text
changedpg_get_viewdef
--- 7.2 +++ 7.3 @@ -1 +1,2 @@ pg_get_viewdef ( viewname ) → text +pg_get_viewdef ( viewOID ) → text
addedpg_opclass_is_visible
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +pg_opclass_is_visible ( opclassOID ) → boolean
addedpg_operator_is_visible
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +pg_operator_is_visible ( operatorOID ) → boolean
addedpg_table_is_visible
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +pg_table_is_visible ( tableOID ) → boolean
addedpg_type_is_visible
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +pg_type_is_visible ( typeOID ) → boolean
changedversion
--- 7.2 +++ 7.3 @@ -1 +1 @@ -version → text +version ( ) → text
addedcurrent_setting
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +current_setting ( setting_name ) → text
addedset_config
--- 7.2 +++ 7.3 @@ -0,0 +1 @@ +set_config ( setting_name, new_value, is_local ) → text