FUNCTIONS / VERSION COMPARISON
What changed?
Functions · PostgreSQL 15 → 16
25 added · 0 removed · 4 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
addederf
--- 15 +++ 16 @@ -0,0 +1 @@ +erf ( double precision ) → double precision
addederfc
--- 15 +++ 16 @@ -0,0 +1 @@ +erfc ( double precision ) → double precision
addedrandom_normal
--- 15 +++ 16 @@ -0,0 +1 @@ +random_normal ( [ mean double precision [, stddev double precision ]] ) → double precision
addeddate_add
--- 15 +++ 16 @@ -0,0 +1 @@ +date_add ( timestamp with time zone, interval [, text ] ) → timestamp with time zone
addeddate_subtract
--- 15 +++ 16 @@ -0,0 +1 @@ +date_subtract ( timestamp with time zone, interval [, text ] ) → timestamp with time zone
addedjson_array
--- 15
+++ 16
@@ -0,0 +1,2 @@
+json_array ( [ { value_expression [ FORMAT JSON ] } [, ...] ] [ { NULL | ABSENT } ON NULL ] [ RETURNING data_type [ FORMAT JSON [ ENCODING UTF8 ] ] ])
+json_array ( [ query_expression ] [ RETURNING data_type [ FORMAT JSON [ ENCODING UTF8 ] ] ])changedjson_object
--- 15
+++ 16
@@ -1,2 +1,3 @@
+json_object ( [ { key_expression { VALUE | ':' } value_expression [ FORMAT JSON [ ENCODING UTF8 ] ] }[, ...] ] [ { NULL | ABSENT } ON NULL ] [ { WITH | WITHOUT } UNIQUE [ KEYS ] ] [ RETURNING data_type [ FORMAT JSON [ ENCODING UTF8 ] ] ])
json_object ( text[] ) → json
json_object ( keys text[], values text[] ) → jsonaddedarray_sample
--- 15 +++ 16 @@ -0,0 +1 @@ +array_sample ( array anyarray, n integer ) → anyarray
addedarray_shuffle
--- 15 +++ 16 @@ -0,0 +1 @@ +array_shuffle ( anyarray ) → anyarray
addedany_value
--- 15 +++ 16 @@ -0,0 +1 @@ +any_value ( anyelement ) → same as input type
addedjson_agg_strict
--- 15 +++ 16 @@ -0,0 +1 @@ +json_agg_strict ( anyelement ) → json
addedjson_arrayagg
--- 15
+++ 16
@@ -0,0 +1 @@
+json_arrayagg ( [ value_expression ] [ ORDER BY sort_expression ] [ { NULL | ABSENT } ON NULL ] [ RETURNING data_type [ FORMAT JSON [ ENCODING UTF8 ] ] ])addedjson_object_agg_strict
--- 15 +++ 16 @@ -0,0 +1 @@ +json_object_agg_strict ( key "any", value "any" ) → json
addedjson_object_agg_unique
--- 15 +++ 16 @@ -0,0 +1 @@ +json_object_agg_unique ( key "any", value "any" ) → json
addedjson_object_agg_unique_strict
--- 15 +++ 16 @@ -0,0 +1 @@ +json_object_agg_unique_strict ( key "any", value "any" ) → json
addedjson_objectagg
--- 15
+++ 16
@@ -0,0 +1 @@
+json_objectagg ( [ { key_expression { VALUE | ':' } value_expression } ] [ { NULL | ABSENT } ON NULL ] [ { WITH | WITHOUT } UNIQUE [ KEYS ] ] [ RETURNING data_type [ FORMAT JSON [ ENCODING UTF8 ] ] ])addedjsonb_agg_strict
--- 15 +++ 16 @@ -0,0 +1 @@ +jsonb_agg_strict ( anyelement ) → jsonb
addedjsonb_object_agg_strict
--- 15 +++ 16 @@ -0,0 +1 @@ +jsonb_object_agg_strict ( key "any", value "any" ) → jsonb
addedjsonb_object_agg_unique
--- 15 +++ 16 @@ -0,0 +1 @@ +jsonb_object_agg_unique ( key "any", value "any" ) → jsonb
addedjsonb_object_agg_unique_strict
--- 15 +++ 16 @@ -0,0 +1 @@ +jsonb_object_agg_unique_strict ( key "any", value "any" ) → jsonb
changedgenerate_series
--- 15 +++ 16 @@ -2,4 +2,4 @@ generate_series ( start bigint, stop bigint [, step bigint ] ) → setof bigint generate_series ( start numeric, stop numeric [, step numeric ] ) → setof numeric generate_series ( start timestamp, stop timestamp, step interval ) → setof timestamp -generate_series ( start timestamp with time zone, stop timestamp with time zone, step interval ) → setof timestamp with time zone +generate_series ( start timestamp with time zone, stop timestamp with time zone, step interval [, timezone text ] ) → setof timestamp with time zone
addedpg_get_partkeydef
--- 15 +++ 16 @@ -0,0 +1 @@ +pg_get_partkeydef ( table oid ) → text
addedpg_input_error_info
--- 15 +++ 16 @@ -0,0 +1 @@ +pg_input_error_info ( string text, type text ) → record ( message text, detail text, hint text, sql_error_code text )
addedpg_input_is_valid
--- 15 +++ 16 @@ -0,0 +1 @@ +pg_input_is_valid ( string text, type text ) → boolean
addedsystem_user
--- 15 +++ 16 @@ -0,0 +1 @@ +system_user → text
addedpg_log_standby_snapshot
--- 15 +++ 16 @@ -0,0 +1 @@ +pg_log_standby_snapshot () → pg_lsn
changedpg_read_binary_file
--- 15 +++ 16 @@ -1 +1 @@ -pg_read_binary_file ( filename text [, offset bigint, length bigint [, missing_ok boolean ]] ) → bytea +pg_read_binary_file ( filename text [, offset bigint, length bigint ] [, missing_ok boolean ] ) → bytea
changedpg_read_file
--- 15 +++ 16 @@ -1 +1 @@ -pg_read_file ( filename text [, offset bigint, length bigint [, missing_ok boolean ]] ) → text +pg_read_file ( filename text [, offset bigint, length bigint ] [, missing_ok boolean ] ) → text
addedpg_split_walfile_name
--- 15 +++ 16 @@ -0,0 +1 @@ +pg_split_walfile_name ( file_name text ) → record ( segment_number numeric, timeline_id bigint )