FUNCTIONS / VERSION COMPARISON
What changed?
Functions · PostgreSQL 9.3 → 9.4
Historical documentation for a PostgreSQL version that is no longer supported.
47 added · 0 removed · 28 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
changedtrim
--- 9.3 +++ 9.4 @@ -1,2 +1,3 @@ trim ( [leading | trailing | both] [characters] from string ) → text +trim ( [leading | trailing | both] [from] string [, characters] ) → text trim ( [both] bytes from string ) → bytea
changeddate_trunc
--- 9.3
+++ 9.4
@@ -1,2 +1,3 @@
date_trunc ( text, timestamp ) → timestamp
+date_trunc ( text, interval ) → interval
date_trunc('field', source)addedmake_date
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +make_date ( year int, month int, day int ) → date
addedmake_interval
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +make_interval ( years int DEFAULT 0, months int DEFAULT 0, weeks int DEFAULT 0, days int DEFAULT 0, hours int DEFAULT 0, mins int DEFAULT 0, secs double precision DEFAULT 0.0 ) → interval
addedmake_time
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +make_time ( hour int, min int, sec double precision ) → time
addedmake_timestamp
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +make_timestamp ( year int, month int, day int, hour int, min int, sec double precision ) → timestamp
addedmake_timestamptz
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +make_timestamptz ( year int, month int, day int, hour int, min int, sec double precision, [ timezone text ] ) → timestamp with time zone
addedpg_sleep_for
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +pg_sleep_for(interval)
addedpg_sleep_until
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +pg_sleep_until(timestamp with time zone)
addedline
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +line ( point, point ) → line
changedunnest
--- 9.3 +++ 9.4 @@ -1 +1,2 @@ unnest ( anyarray ) → setof anyelement +unnest ( anyarray, anyarray [, ...] ) → setof anyelement, anyelement [, ...]
changedarray_to_json
--- 9.3 +++ 9.4 @@ -1 +1 @@ -array_to_json ( anyarray [, pretty_bool] ) → json +array_to_json ( anyarray [, pretty_bool] )
changedjson_array_elements
--- 9.3 +++ 9.4 @@ -1 +1 @@ -json_array_elements ( json ) → SETOF json +json_array_elements ( json ) → setof json setof jsonb
addedjson_array_elements_text
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +json_array_elements_text ( json ) → setof text
addedjson_build_array
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +json_build_array ( VARIADIC "any" )
addedjson_build_object
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +json_build_object ( VARIADIC "any" )
changedjson_each
--- 9.3 +++ 9.4 @@ -1 +1 @@ -json_each ( json ) → SETOF key text, value json +json_each ( json ) → setof key text, value json setof key text, value jsonb
changedjson_each_text
--- 9.3 +++ 9.4 @@ -1 +1 @@ -json_each_text ( from_json json ) → SETOF key text, value text +json_each_text ( json ) → setof key text, value text
changedjson_extract_path
--- 9.3 +++ 9.4 @@ -1 +1 @@ -json_extract_path ( from_json json, VARIADIC path_elems text[] ) → json +json_extract_path ( from_json json, VARIADIC path_elems text[] ) → json jsonb
addedjson_object
--- 9.3 +++ 9.4 @@ -0,0 +1,2 @@ +json_object ( text[] ) +json_object ( keys text[], values text[] )
changedjson_object_keys
--- 9.3 +++ 9.4 @@ -1 +1 @@ -json_object_keys ( json ) → SETOF text +json_object_keys ( json ) → setof text
changedjson_populate_record
--- 9.3 +++ 9.4 @@ -1 +1 @@ -json_populate_record ( base anyelement, from_json json, [, use_json_as_text bool=false] ) → anyelement +json_populate_record ( base anyelement, from_json json ) → anyelement
changedjson_populate_recordset
--- 9.3 +++ 9.4 @@ -1 +1 @@ -json_populate_recordset ( base anyelement, from_json json, [, use_json_as_text bool=false] ) → SETOF anyelement +json_populate_recordset ( base anyelement, from_json json ) → setof anyelement
addedjson_to_record
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +json_to_record ( json ) → record
addedjson_to_recordset
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +json_to_recordset ( json ) → setof record
addedjson_typeof
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +json_typeof ( json ) → text
addedjsonb_array_elements
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +jsonb_array_elements ( jsonb ) → setof json setof jsonb
addedjsonb_array_elements_text
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +jsonb_array_elements_text ( jsonb ) → setof text
addedjsonb_array_length
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +jsonb_array_length ( jsonb ) → int
addedjsonb_each
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +jsonb_each ( jsonb ) → setof key text, value json setof key text, value jsonb
addedjsonb_each_text
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +jsonb_each_text ( jsonb ) → setof key text, value text
addedjsonb_extract_path
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +jsonb_extract_path ( from_json jsonb, VARIADIC path_elems text[] ) → json jsonb
addedjsonb_extract_path_text
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +jsonb_extract_path_text ( from_json jsonb, VARIADIC path_elems text[] ) → text
addedjsonb_object_keys
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +jsonb_object_keys ( jsonb ) → setof text
addedjsonb_populate_record
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +jsonb_populate_record ( base anyelement, from_json jsonb ) → anyelement
addedjsonb_populate_recordset
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +jsonb_populate_recordset ( base anyelement, from_json jsonb ) → setof anyelement
addedjsonb_to_record
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +jsonb_to_record ( jsonb ) → record
addedjsonb_to_recordset
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +jsonb_to_recordset ( jsonb ) → setof record
addedjsonb_typeof
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +jsonb_typeof ( jsonb ) → text
changedrow_to_json
--- 9.3 +++ 9.4 @@ -1 +1 @@ -row_to_json ( record [, pretty_bool] ) → json +row_to_json ( record [, pretty_bool] )
changedto_json
--- 9.3 +++ 9.4 @@ -1 +1 @@ -to_json ( anyelement ) → json +to_json ( anyelement )
addedcardinality
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +cardinality ( anyarray ) → int
changedcume_dist
--- 9.3 +++ 9.4 @@ -1 +1,2 @@ +cume_dist ( args ) WITHIN GROUP (ORDER BY sorted_args) → double precision cume_dist ( ) → double precision
changeddense_rank
--- 9.3 +++ 9.4 @@ -1 +1,2 @@ +dense_rank ( args ) WITHIN GROUP (ORDER BY sorted_args) → bigint dense_rank ( ) → bigint
addedjson_object_agg
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +json_object_agg ( name, value ) → json
addedmode
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +mode ( ) WITHIN GROUP (ORDER BY sort_expression) → same as sort expression
changedpercent_rank
--- 9.3 +++ 9.4 @@ -1 +1,2 @@ +percent_rank ( args ) WITHIN GROUP (ORDER BY sorted_args) → double precision percent_rank ( ) → double precision
addedpercentile_cont
--- 9.3 +++ 9.4 @@ -0,0 +1,2 @@ +percentile_cont ( fraction ) WITHIN GROUP (ORDER BY sort_expression) → same as sort expression +percentile_cont ( fractions ) WITHIN GROUP (ORDER BY sort_expression) → array of sort expression's type
addedpercentile_disc
--- 9.3 +++ 9.4 @@ -0,0 +1,2 @@ +percentile_disc ( fraction ) WITHIN GROUP (ORDER BY sort_expression) → same as sort expression +percentile_disc ( fractions ) WITHIN GROUP (ORDER BY sort_expression) → array of sort expression's type
changedrank
--- 9.3 +++ 9.4 @@ -1 +1,2 @@ +rank ( args ) WITHIN GROUP (ORDER BY sorted_args) → bigint rank ( ) → bigint
addedto_regclass
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +to_regclass ( rel_name ) → regclass
addedto_regoper
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +to_regoper ( operator_name ) → regoper
addedto_regoperator
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +to_regoperator ( operator_name ) → regoperator
addedto_regproc
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +to_regproc ( func_name ) → regproc
addedto_regprocedure
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +to_regprocedure ( func_name ) → regprocedure
addedto_regtype
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +to_regtype ( type_name ) → regtype
addedpg_create_logical_replication_slot
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +pg_create_logical_replication_slot ( slot_name name, plugin name ) → (slot_name name, xlog_position pg_lsn)
addedpg_create_physical_replication_slot
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +pg_create_physical_replication_slot ( slot_name name ) → (slot_name name, xlog_position pg_lsn)
changedpg_create_restore_point
--- 9.3 +++ 9.4 @@ -1 +1 @@ -pg_create_restore_point ( name text ) → text +pg_create_restore_point ( name text ) → pg_lsn
changedpg_current_xlog_insert_location
--- 9.3 +++ 9.4 @@ -1 +1 @@ -pg_current_xlog_insert_location ( ) → text +pg_current_xlog_insert_location ( ) → pg_lsn
changedpg_current_xlog_location
--- 9.3 +++ 9.4 @@ -1 +1 @@ -pg_current_xlog_location ( ) → text +pg_current_xlog_location ( ) → pg_lsn
addedpg_drop_replication_slot
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +pg_drop_replication_slot ( slot_name name ) → void
addedpg_filenode_relation
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +pg_filenode_relation ( tablespace oid, filenode oid ) → regclass
changedpg_last_xlog_receive_location
--- 9.3 +++ 9.4 @@ -1 +1 @@ -pg_last_xlog_receive_location ( ) → text +pg_last_xlog_receive_location ( ) → pg_lsn
changedpg_last_xlog_replay_location
--- 9.3 +++ 9.4 @@ -1 +1 @@ -pg_last_xlog_replay_location ( ) → text +pg_last_xlog_replay_location ( ) → pg_lsn
addedpg_logical_slot_get_binary_changes
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +pg_logical_slot_get_binary_changes ( slot_name name, upto_lsn pg_lsn, upto_nchanges int, VARIADIC options text[] ) → (location pg_lsn, xid xid, data bytea)
addedpg_logical_slot_get_changes
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +pg_logical_slot_get_changes ( slot_name name, upto_lsn pg_lsn, upto_nchanges int, VARIADIC options text[] ) → (location pg_lsn, xid xid, data text)
addedpg_logical_slot_peek_binary_changes
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +pg_logical_slot_peek_binary_changes ( slot_name name, upto_lsn pg_lsn, upto_nchanges int, VARIADIC options text[] ) → (location pg_lsn, xid xid, data bytea)
addedpg_logical_slot_peek_changes
--- 9.3 +++ 9.4 @@ -0,0 +1 @@ +pg_logical_slot_peek_changes ( slot_name name, upto_lsn pg_lsn, upto_nchanges int, VARIADIC options text[] ) → (location text, xid xid, data text)
changedpg_start_backup
--- 9.3 +++ 9.4 @@ -1 +1 @@ -pg_start_backup ( label text [, fast boolean ] ) → text +pg_start_backup ( label text [, fast boolean ] ) → pg_lsn
changedpg_stop_backup
--- 9.3 +++ 9.4 @@ -1 +1 @@ -pg_stop_backup ( ) → text +pg_stop_backup ( ) → pg_lsn
changedpg_switch_xlog
--- 9.3 +++ 9.4 @@ -1 +1 @@ -pg_switch_xlog ( ) → text +pg_switch_xlog ( ) → pg_lsn
changedpg_xlog_location_diff
--- 9.3 +++ 9.4 @@ -1 +1 @@ -pg_xlog_location_diff ( location text, location text ) → numeric +pg_xlog_location_diff ( location pg_lsn, location pg_lsn ) → numeric
changedpg_xlogfile_name
--- 9.3 +++ 9.4 @@ -1 +1 @@ -pg_xlogfile_name ( location text ) → text +pg_xlogfile_name ( location pg_lsn ) → text
changedpg_xlogfile_name_offset
--- 9.3 +++ 9.4 @@ -1 +1 @@ -pg_xlogfile_name_offset ( location text ) → text, integer +pg_xlogfile_name_offset ( location pg_lsn ) → text, integer