FUNCTIONS / VERSION COMPARISON
What changed?
Functions · PostgreSQL 9.2 → 9.3
Historical documentation for a PostgreSQL version that is no longer supported.
17 added · 0 removed · 4 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
changedformat
--- 9.2 +++ 9.3 @@ -1 +1,2 @@ -format ( formatstr text [, str "any" [, ...] ] ) → text +format ( formatstr text [, formatarg "any" [, ...] ] ) → text +format(formatstr text [, formatarg "any" [, ...] ])
changedarray_to_json
--- 9.2 +++ 9.3 @@ -1 +1 @@ -array_to_json ( anyarray [, pretty_bool] ) +array_to_json ( anyarray [, pretty_bool] ) → json
addedjson_array_elements
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +json_array_elements ( json ) → SETOF json
addedjson_array_length
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +json_array_length ( json ) → int
addedjson_each
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +json_each ( json ) → SETOF key text, value json
addedjson_each_text
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +json_each_text ( from_json json ) → SETOF key text, value text
addedjson_extract_path
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +json_extract_path ( from_json json, VARIADIC path_elems text[] ) → json
addedjson_extract_path_text
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +json_extract_path_text ( from_json json, VARIADIC path_elems text[] ) → text
addedjson_object_keys
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +json_object_keys ( json ) → SETOF text
addedjson_populate_record
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +json_populate_record ( base anyelement, from_json json, [, use_json_as_text bool=false] ) → anyelement
addedjson_populate_recordset
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +json_populate_recordset ( base anyelement, from_json json, [, use_json_as_text bool=false] ) → SETOF anyelement
changedrow_to_json
--- 9.2 +++ 9.3 @@ -1 +1 @@ -row_to_json ( record [, pretty_bool] ) +row_to_json ( record [, pretty_bool] ) → json
addedto_json
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +to_json ( anyelement ) → json
changedarray_fill
--- 9.2 +++ 9.3 @@ -1 +1 @@ -array_fill ( anyelement, int[], [, int[]] ) → anyarray +array_fill ( anyelement, int[] [, int[]] ) → anyarray
addedarray_remove
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +array_remove ( anyarray, anyelement ) → anyarray
addedarray_replace
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +array_replace ( anyarray, anyelement, anyelement ) → anyarray
addedjson_agg
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +json_agg ( expression ) → json
addedpg_identify_object
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +pg_identify_object ( catalog_id oid, object_id oid, object_sub_id integer ) → type text, schema text, name text, identity text
addedpg_backup_start_time
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +pg_backup_start_time ( ) → timestamp with time zone
addedpg_is_in_backup
--- 9.2 +++ 9.3 @@ -0,0 +1 @@ +pg_is_in_backup ( ) → bool