FUNCTIONS / VERSION COMPARISON
What changed?
Functions · PostgreSQL 9.0 → 9.1
Historical documentation for a PostgreSQL version that is no longer supported.
24 added · 0 removed · 6 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
addedconcat
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +concat ( str "any" [, str "any" [, ...] ] ) → text
addedconcat_ws
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +concat_ws ( sep text, str "any" [, str "any" [, ...] ] ) → text
addedformat
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +format ( formatstr text [, str "any" [, ...] ] ) → text
addedleft
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +left ( str text, n int ) → text
changedlength
--- 9.0 +++ 9.1 @@ -1,4 +1,4 @@ length ( string ) → int -length ( stringbytea, encoding name ) → int +length ( string bytea, encoding name ) → int length ( object ) → double precision length ( tsvector ) → integer
addedreverse
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +reverse ( str ) → text
addedright
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +right ( str text, n int ) → text
changedstring_to_array
--- 9.0 +++ 9.1 @@ -1 +1 @@ -string_to_array ( text, text ) → text[] +string_to_array ( text, text [, text] ) → text[]
addedxml_is_well_formed
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +xml_is_well_formed(text)
addedxml_is_well_formed_content
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +xml_is_well_formed_content(text)
addedxml_is_well_formed_document
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +xml_is_well_formed_document(text)
addedXMLEXISTS
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +XMLEXISTS(text PASSING [BY REF] xml [BY REF])
changedxpath
--- 9.0 +++ 9.1 @@ -1 +1 @@ -xpath(xpath, xml[, nsarray]) +xpath(xpath, xml [, nsarray])
addedxpath_exists
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +xpath_exists(xpath, xml [, nsarray])
changedarray_to_string
--- 9.0 +++ 9.1 @@ -1 +1 @@ -array_to_string ( anyarray, text ) → text +array_to_string ( anyarray, text [, text] ) → text
addedpg_collation_is_visible
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +pg_collation_is_visible ( collation_oid ) → boolean
addedpg_describe_object
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +pg_describe_object ( catalog_id, object_id, object_sub_id ) → text
changedpg_get_expr
--- 9.0 +++ 9.1 @@ -1,2 +1,2 @@ -pg_get_expr ( expr_text, relation_oid ) → text -pg_get_expr ( expr_text, relation_oid, pretty_bool ) → text +pg_get_expr ( pg_node_tree, relation_oid ) → text +pg_get_expr ( pg_node_tree, relation_oid, pretty_bool ) → text
addedpg_options_to_table
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +pg_options_to_table ( reloptions ) → setof record
addedpg_advisory_xact_lock
--- 9.0 +++ 9.1 @@ -0,0 +1,2 @@ +pg_advisory_xact_lock ( key bigint ) → void +pg_advisory_xact_lock ( key1 int, key2 int ) → void
addedpg_advisory_xact_lock_shared
--- 9.0 +++ 9.1 @@ -0,0 +1,2 @@ +pg_advisory_xact_lock_shared ( key bigint ) → void +pg_advisory_xact_lock_shared ( key1 int, key2 int ) → void
addedpg_create_restore_point
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +pg_create_restore_point ( name text ) → text
addedpg_is_xlog_replay_paused
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +pg_is_xlog_replay_paused ( ) → bool
addedpg_last_xact_replay_timestamp
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +pg_last_xact_replay_timestamp ( ) → timestamp with time zone
addedpg_read_binary_file
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +pg_read_binary_file ( filename text [, offset bigint, length bigint] ) → bytea
changedpg_read_file
--- 9.0 +++ 9.1 @@ -1 +1 @@ -pg_read_file ( filename text, offset bigint, length bigint ) → text +pg_read_file ( filename text [, offset bigint, length bigint] ) → text
addedpg_try_advisory_xact_lock
--- 9.0 +++ 9.1 @@ -0,0 +1,2 @@ +pg_try_advisory_xact_lock ( key bigint ) → boolean +pg_try_advisory_xact_lock ( key1 int, key2 int ) → boolean
addedpg_try_advisory_xact_lock_shared
--- 9.0 +++ 9.1 @@ -0,0 +1,2 @@ +pg_try_advisory_xact_lock_shared ( key bigint ) → boolean +pg_try_advisory_xact_lock_shared ( key1 int, key2 int ) → boolean
addedpg_xlog_replay_pause
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +pg_xlog_replay_pause ( ) → void
addedpg_xlog_replay_resume
--- 9.0 +++ 9.1 @@ -0,0 +1 @@ +pg_xlog_replay_resume ( ) → void