FUNCTIONS / VERSION COMPARISON
What changed?
Functions · PostgreSQL 9.4 → 9.5
Historical documentation for a PostgreSQL version that is no longer supported.
40 added · 0 removed · 10 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
addedfactorial
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +factorial ( bigint ) → numeric
changedwidth_bucket
--- 9.4 +++ 9.5 @@ -1,2 +1,3 @@ -width_bucket ( op numeric, b1 numeric, b2 numeric, count int ) → int -width_bucket ( op dp, b1 dp, b2 dp, count int ) → int +width_bucket ( operand dp, b1 dp, b2 dp, count int ) → int +width_bucket ( operand numeric, b1 numeric, b2 numeric, count int ) → int +width_bucket ( operand anyelement, thresholds anyarray ) → int
addedbound_box
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +bound_box ( box, box ) → box
changedbox
--- 9.4 +++ 9.5 @@ -1,3 +1,4 @@ box ( circle ) → box +box ( point ) → box box ( point, point ) → box box ( polygon ) → box
addedinet_merge
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +inet_merge ( inet, inet ) → cidr
addedinet_same_family
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +inet_same_family ( inet, inet ) → boolean
addedjson_strip_nulls
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +json_strip_nulls ( from_json json ) → json jsonb
addedjsonb_build_array
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +jsonb_build_array ( VARIADIC "any" )
addedjsonb_build_object
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +jsonb_build_object ( VARIADIC "any" )
addedjsonb_object
--- 9.4 +++ 9.5 @@ -0,0 +1,2 @@ +jsonb_object ( text[] ) +jsonb_object ( keys text[], values text[] )
addedjsonb_pretty
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +jsonb_pretty ( from_json jsonb ) → text
addedjsonb_set
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +jsonb_set ( target jsonb, path text[], new_value jsonb [, create_missing boolean] ) → jsonb
addedjsonb_strip_nulls
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +jsonb_strip_nulls ( from_json jsonb ) → json jsonb
addedto_jsonb
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +to_jsonb ( anyelement )
addedarray_position
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +array_position ( anyarray, anyelement [, int] ) → int
addedarray_positions
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +array_positions ( anyarray, anyelement ) → int[]
addedrange_merge
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +range_merge ( anyrange, anyrange ) → anyrange
changedarray_agg
--- 9.4 +++ 9.5 @@ -1 +1,2 @@ array_agg ( expression ) → array of the argument type +array_agg ( expression ) → same as argument data type
addedGROUPING
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +GROUPING ( args... ) → integer
addedjsonb_agg
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +jsonb_agg ( expression ) → jsonb
addedjsonb_object_agg
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +jsonb_object_agg ( name, value ) → jsonb
changedgenerate_series
--- 9.4 +++ 9.5 @@ -1,3 +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 ) → setof int, setof bigint, or setof numeric (same as argument type) +generate_series ( start, stop, step ) → setof int, setof bigint or setof numeric (same as argument type) generate_series ( start, stop, step interval ) → setof timestamp or setof timestamp with time zone (same as argument type)
changedpg_describe_object
--- 9.4 +++ 9.5 @@ -1 +1 @@ -pg_describe_object ( catalog_id, object_id, object_sub_id ) → text +pg_describe_object ( classid oid, objid oid, objsubid integer ) → text
addedpg_get_object_address
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_get_object_address ( type text, name text[], args text[] ) → classid oid, objid oid, objsubid integer
changedpg_identify_object
--- 9.4 +++ 9.5 @@ -1 +1 @@ -pg_identify_object ( catalog_id oid, object_id oid, object_sub_id integer ) → type text, schema text, name text, identity text +pg_identify_object ( classid oid, objid oid, objsubid integer ) → type text, schema text, name text, identity text
addedpg_identify_object_as_address
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_identify_object_as_address ( classid oid, objid oid, objsubid integer ) → type text, object_names text[], object_args text[]
addedpg_last_committed_xact
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_last_committed_xact ( ) → xid xid, timestamp timestamp with time zone
addedpg_xact_commit_timestamp
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_xact_commit_timestamp ( xid ) → timestamp with time zone
addedrow_security_active
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +row_security_active ( table ) → boolean
addedto_regnamespace
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +to_regnamespace ( schema_name ) → regnamespace
addedto_regrole
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +to_regrole ( role_name ) → regrole
addedbrin_summarize_new_values
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +brin_summarize_new_values ( index_oid regclass ) → integer
changedpg_ls_dir
--- 9.4 +++ 9.5 @@ -1 +1 @@ -pg_ls_dir ( dirname text ) → setof text +pg_ls_dir ( dirname text [, missing_ok boolean, include_dot_dirs boolean] ) → setof text
changedpg_read_binary_file
--- 9.4 +++ 9.5 @@ -1 +1 @@ -pg_read_binary_file ( filename text [, offset bigint, length bigint] ) → bytea +pg_read_binary_file ( filename text [, offset bigint, length bigint [, missing_ok boolean] ] ) → bytea
changedpg_read_file
--- 9.4 +++ 9.5 @@ -1 +1 @@ -pg_read_file ( filename text [, offset bigint, length bigint] ) → text +pg_read_file ( filename text [, offset bigint, length bigint [, missing_ok boolean] ] ) → text
addedpg_replication_origin_advance
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_replication_origin_advance ( node_name text, pos pg_lsn ) → void
addedpg_replication_origin_create
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_replication_origin_create ( node_name text ) → oid
addedpg_replication_origin_drop
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_replication_origin_drop ( node_name text ) → void
addedpg_replication_origin_oid
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_replication_origin_oid ( node_name text ) → oid
addedpg_replication_origin_progress
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_replication_origin_progress ( node_name text, flush bool ) → pg_lsn
addedpg_replication_origin_session_is_setup
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_replication_origin_session_is_setup ( ) → bool
addedpg_replication_origin_session_progress
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_replication_origin_session_progress ( flush bool ) → pg_lsn
addedpg_replication_origin_session_reset
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_replication_origin_session_reset ( ) → void
addedpg_replication_origin_session_setup
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_replication_origin_session_setup ( node_name text ) → void
addedpg_replication_origin_xact_reset
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_replication_origin_xact_reset ( origin_lsn pg_lsn, origin_timestamp timestamptz ) → void
addedpg_replication_origin_xact_setup
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_replication_origin_xact_setup ( origin_lsn pg_lsn, origin_timestamp timestamptz ) → void
changedpg_stat_file
--- 9.4 +++ 9.5 @@ -1 +1 @@ -pg_stat_file ( filename text ) → record +pg_stat_file ( filename text[, missing_ok boolean] ) → record
addedpg_event_trigger_table_rewrite_oid
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_event_trigger_table_rewrite_oid ( ) → Oid
addedpg_event_trigger_table_rewrite_reason
--- 9.4 +++ 9.5 @@ -0,0 +1 @@ +pg_event_trigger_table_rewrite_reason ( ) → int