FUNCTIONS / VERSION COMPARISON
What changed?
Functions · PostgreSQL 9.1 → 9.2
Historical documentation for a PostgreSQL version that is no longer supported.
14 added · 0 removed · 5 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
changedlower
--- 9.1 +++ 9.2 @@ -1 +1,2 @@ lower ( string ) → text +lower ( anyrange ) → range's element type
changedupper
--- 9.1 +++ 9.2 @@ -1 +1,2 @@ upper ( string ) → text +upper ( anyrange ) → range's element type
addedarray_to_json
--- 9.1 +++ 9.2 @@ -0,0 +1 @@ +array_to_json ( anyarray [, pretty_bool] )
addedrow_to_json
--- 9.1 +++ 9.2 @@ -0,0 +1 @@ +row_to_json ( record [, pretty_bool] )
addedisempty
--- 9.1 +++ 9.2 @@ -0,0 +1 @@ +isempty ( anyrange ) → boolean
addedlower_inc
--- 9.1 +++ 9.2 @@ -0,0 +1 @@ +lower_inc ( anyrange ) → boolean
addedlower_inf
--- 9.1 +++ 9.2 @@ -0,0 +1 @@ +lower_inf ( anyrange ) → boolean
addedupper_inc
--- 9.1 +++ 9.2 @@ -0,0 +1 @@ +upper_inc ( anyrange ) → boolean
addedupper_inf
--- 9.1 +++ 9.2 @@ -0,0 +1 @@ +upper_inf ( anyrange ) → boolean
changedstring_agg
--- 9.1 +++ 9.2 @@ -1 +1 @@ -string_agg ( expression, delimiter ) → text +string_agg ( expression, delimiter ) → same as argument types
addedcurrent_role
--- 9.1 +++ 9.2 @@ -0,0 +1 @@ +current_role → name
addedhas_type_privilege
--- 9.1 +++ 9.2 @@ -0,0 +1,2 @@ +has_type_privilege ( user, type, privilege ) → boolean +has_type_privilege ( type, privilege ) → boolean
changedpg_get_viewdef
--- 9.1 +++ 9.2 @@ -2,3 +2,4 @@ pg_get_viewdef ( view_name, pretty_bool ) → text pg_get_viewdef ( view_oid ) → text pg_get_viewdef ( view_oid, pretty_bool ) → text +pg_get_viewdef ( view_oid, wrap_column_int ) → text
addedpg_opfamily_is_visible
--- 9.1 +++ 9.2 @@ -0,0 +1 @@ +pg_opfamily_is_visible ( opclass_oid ) → boolean
addedpg_tablespace_location
--- 9.1 +++ 9.2 @@ -0,0 +1 @@ +pg_tablespace_location ( tablespace_oid ) → text
addedpg_trigger_depth
--- 9.1 +++ 9.2 @@ -0,0 +1 @@ +pg_trigger_depth ( ) → int
addedpg_export_snapshot
--- 9.1 +++ 9.2 @@ -0,0 +1 @@ +pg_export_snapshot ( ) → text
changedpg_size_pretty
--- 9.1 +++ 9.2 @@ -1 +1,2 @@ pg_size_pretty ( bigint ) → text +pg_size_pretty ( numeric ) → text
addedpg_xlog_location_diff
--- 9.1 +++ 9.2 @@ -0,0 +1 @@ +pg_xlog_location_diff ( location text, location text ) → numeric