Functions / Version comparison
What changed?
Functions · PostgreSQL 8.3 → 8.4
Historical documentation for a PostgreSQL version that is no longer supported.
35 added · 0 removed · 13 changed · 0 coverage changes. These are changes between the pinned reference snapshots.
changedabs
--- 8.3 +++ 8.4 @@ -1 +1 @@ -abs ( x ) → (same as x) +abs ( x ) → (same as input)
addeddiv
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +div ( y numeric, x numeric ) → numeric
addedquote_nullable
--- 8.3 +++ 8.4 @@ -0,0 +1,2 @@ +quote_nullable ( string text ) → text +quote_nullable ( value anyelement ) → text
changeddecode
--- 8.3 +++ 8.4 @@ -1 +1 @@ -decode ( string text, type text ) → bytea +decode ( string text, format text ) → bytea
changedencode
--- 8.3 +++ 8.4 @@ -1,2 +1 @@ -encode ( data bytea, type text ) → text -encode ( string bytea, type text ) → text +encode ( data bytea, format text ) → text
changedisfinite
--- 8.3 +++ 8.4 @@ -1,2 +1,3 @@ +isfinite ( date ) → boolean isfinite ( timestamp ) → boolean isfinite ( interval ) → boolean
addedunnest
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +unnest ( anyarray ) → setof anyelement
changedxmlagg
--- 8.3 +++ 8.4 @@ -1 +1,2 @@ xmlagg(xml) +xmlagg ( expression ) → xml
changedxmlroot
--- 8.3 +++ 8.4 @@ -1 +1 @@ -xmlroot(xml, version text|no value [, standalone yes|no|no value]) +xmlroot(xml, version text | no value [, standalone yes|no|no value])
addedarray_fill
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +array_fill ( anyelement, int[], [, int[]] ) → anyarray
addedarray_length
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +array_length ( anyarray, int ) → int
addedarray_ndims
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +array_ndims ( anyarray ) → int
addedarray_agg
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +array_agg ( expression ) → array of the argument type
changedavg
--- 8.3 +++ 8.4 @@ -1 +1 @@ -avg ( expression ) → numeric for any integer type argument, double precision for a floating-point argument, otherwise the same as the argument data type +avg ( expression ) → numeric for any integer-type argument, double precision for a floating-point argument, otherwise the same as the argument data type
addedcume_dist
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +cume_dist ( ) → double precision
addeddense_rank
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +dense_rank ( ) → bigint
addedpercent_rank
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +percent_rank ( ) → double precision
addedrank
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +rank ( ) → bigint
addedfirst_value
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +first_value ( value any ) → same type as value
addedlag
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +lag ( value any [, offset integer [, default any ]] ) → same type as value
addedlast_value
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +last_value ( value any ) → same type as value
addedlead
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +lead ( value any [, offset integer [, default any ]] ) → same type as value
addednth_value
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +nth_value ( value any, nth integer ) → same type as value
addedntile
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +ntile ( num_buckets integer ) → integer
addedrow_number
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +row_number ( ) → bigint
changedgenerate_series
--- 8.3 +++ 8.4 @@ -1,2 +1,3 @@ generate_series ( start, stop ) → setof int or setof bigint (same as argument type) generate_series ( start, stop, step ) → setof int or setof bigint (same as argument type) +generate_series ( start, stop, step interval ) → setof timestamp or setof timestamp with time zone (same as argument type)
addedgenerate_subscripts
--- 8.3 +++ 8.4 @@ -0,0 +1,2 @@ +generate_subscripts ( array anyarray, dim int ) → setof int +generate_subscripts ( array anyarray, dim int, reverse boolean ) → setof int
addedcurrent_catalog
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +current_catalog → name
addedcurrent_query
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +current_query ( ) → text
changedcurrent_schema
--- 8.3 +++ 8.4 @@ -1 +1 @@ -current_schema ( ) → name +current_schema → name
addedhas_any_column_privilege
--- 8.3 +++ 8.4 @@ -0,0 +1,2 @@ +has_any_column_privilege ( user, table, privilege ) → boolean +has_any_column_privilege ( table, privilege ) → boolean
addedhas_column_privilege
--- 8.3 +++ 8.4 @@ -0,0 +1,2 @@ +has_column_privilege ( user, table, column, privilege ) → boolean +has_column_privilege ( table, column, privilege ) → boolean
addedhas_foreign_data_wrapper_privilege
--- 8.3 +++ 8.4 @@ -0,0 +1,2 @@ +has_foreign_data_wrapper_privilege ( user, fdw, privilege ) → boolean +has_foreign_data_wrapper_privilege ( fdw, privilege ) → boolean
addedhas_server_privilege
--- 8.3 +++ 8.4 @@ -0,0 +1,2 @@ +has_server_privilege ( user, server, privilege ) → boolean +has_server_privilege ( server, privilege ) → boolean
addedpg_backend_pid
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +pg_backend_pid ( ) → int
addedpg_conf_load_time
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +pg_conf_load_time ( ) → timestamp with time zone
addedpg_get_function_arguments
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +pg_get_function_arguments ( func_oid ) → text
addedpg_get_function_identity_arguments
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +pg_get_function_identity_arguments ( func_oid ) → text
addedpg_get_function_result
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +pg_get_function_result ( func_oid ) → text
addedpg_get_functiondef
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +pg_get_functiondef ( func_oid ) → text
addedpg_get_keywords
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +pg_get_keywords ( ) → setof record
changedpg_get_userbyid
--- 8.3 +++ 8.4 @@ -1 +1 @@ -pg_get_userbyid ( roleid ) → name +pg_get_userbyid ( role_oid ) → name
addedpg_typeof
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +pg_typeof ( any ) → regtype
changedpg_relation_size
--- 8.3 +++ 8.4 @@ -1,2 +1,2 @@ -pg_relation_size ( oid ) → bigint -pg_relation_size ( text ) → bigint +pg_relation_size ( relation regclass, fork text ) → bigint +pg_relation_size ( relation regclass ) → bigint
changedpg_start_backup
--- 8.3 +++ 8.4 @@ -1 +1 @@ -pg_start_backup ( label text ) → text +pg_start_backup ( label text [, fast boolean ] ) → text
addedpg_terminate_backend
--- 8.3 +++ 8.4 @@ -0,0 +1 @@ +pg_terminate_backend ( pid int ) → boolean
changedpg_total_relation_size
--- 8.3 +++ 8.4 @@ -1,2 +1 @@ -pg_total_relation_size ( oid ) → bigint -pg_total_relation_size ( text ) → bigint +pg_total_relation_size ( regclass ) → bigint