Functions / Version comparison
What changed?
Functions · PostgreSQL 8.4 → 9.0
Historical documentation for a PostgreSQL version that is no longer supported.
10 added · 0 removed · 5 changed. These are changes between the pinned reference snapshots.
changedoverlay
--- 8.4 +++ 9.0 @@ -1 +1,2 @@ overlay ( string placing string from int [for int] ) → text +overlay ( string placing string from int [for int] ) → bytea
addedstring_agg
--- 8.4 +++ 9.0 @@ -0,0 +1 @@ +string_agg ( expression, delimiter ) → text
changedsum
--- 8.4 +++ 9.0 @@ -1 +1 @@ -sum ( expression ) → bigint for smallint or int arguments, numeric for bigint arguments, double precision for floating-point arguments, otherwise the same as the argument data type +sum ( expression ) → bigint for smallint or int arguments, numeric for bigint arguments, otherwise the same as the argument data type
changedlag
--- 8.4 +++ 9.0 @@ -1 +1 @@ -lag ( value any [, offset integer [, default any ]] ) → same type as value +lag ( value anyelement [, offset integer [, default anyelement ]] ) → same type as value
changedlead
--- 8.4 +++ 9.0 @@ -1 +1 @@ -lead ( value any [, offset integer [, default any ]] ) → same type as value +lead ( value anyelement [, offset integer [, default anyelement ]] ) → same type as value
addedhas_sequence_privilege
--- 8.4 +++ 9.0 @@ -0,0 +1,2 @@ +has_sequence_privilege ( user, sequence, privilege ) → boolean +has_sequence_privilege ( sequence, privilege ) → boolean
changedpg_get_triggerdef
--- 8.4 +++ 9.0 @@ -1 +1,2 @@ pg_get_triggerdef ( trigger_oid ) → text +pg_get_triggerdef ( trigger_oid, pretty_bool ) → text
addedpg_listening_channels
--- 8.4 +++ 9.0 @@ -0,0 +1 @@ +pg_listening_channels ( ) → setof text
addedpg_indexes_size
--- 8.4 +++ 9.0 @@ -0,0 +1 @@ +pg_indexes_size ( regclass ) → bigint
addedpg_is_in_recovery
--- 8.4 +++ 9.0 @@ -0,0 +1 @@ +pg_is_in_recovery ( ) → bool
addedpg_last_xlog_receive_location
--- 8.4 +++ 9.0 @@ -0,0 +1 @@ +pg_last_xlog_receive_location ( ) → text
addedpg_last_xlog_replay_location
--- 8.4 +++ 9.0 @@ -0,0 +1 @@ +pg_last_xlog_replay_location ( ) → text
addedpg_relation_filenode
--- 8.4 +++ 9.0 @@ -0,0 +1 @@ +pg_relation_filenode ( relation regclass ) → oid
addedpg_relation_filepath
--- 8.4 +++ 9.0 @@ -0,0 +1 @@ +pg_relation_filepath ( relation regclass ) → text
addedpg_table_size
--- 8.4 +++ 9.0 @@ -0,0 +1 @@ +pg_table_size ( regclass ) → bigint