FUNCTIONS / VERSION COMPARISON
What changed?
Functions · PostgreSQL 9.5 → 9.6
Historical documentation for a PostgreSQL version that is no longer supported.
32 added · 0 removed · 8 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
addednum_nonnulls
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +num_nonnulls ( VARIADIC "any" )
addednum_nulls
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +num_nulls ( VARIADIC "any" )
addedacosd
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +acosd ( x )
addedasind
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +asind ( x )
addedatan2d
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +atan2d ( y, x )
addedatand
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +atand ( x )
addedcosd
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +cosd ( x )
addedcotd
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +cotd ( x )
addedscale
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +scale ( numeric ) → integer
addedsind
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +sind ( x )
addedtand
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +tand ( x )
addedparse_ident
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +parse_ident ( qualified_identifier text [, strictmode boolean DEFAULT true ] ) → text[]
addedarray_to_tsvector
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +array_to_tsvector ( text[] ) → tsvector
addedphraseto_tsquery
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +phraseto_tsquery ( [ config regconfig , ] query text ) → tsquery
changedsetweight
--- 9.5 +++ 9.6 @@ -1 +1,2 @@ -setweight ( tsvector, "char" ) → tsvector +setweight ( vector tsvector, weight "char" ) → tsvector +setweight ( vector tsvector, weight "char", lexemes text[] ) → tsvector
addedts_delete
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +ts_delete ( vector tsvector, lexeme text ) → tsvector +ts_delete ( vector tsvector, lexemes text[] ) → tsvector
addedts_filter
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +ts_filter ( vector tsvector, weights "char"[] ) → tsvector
addedtsquery_phrase
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +tsquery_phrase ( query1 tsquery, query2 tsquery ) → tsquery +tsquery_phrase ( query1 tsquery, query2 tsquery, distance integer ) → tsquery
addedtsvector_to_array
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +tsvector_to_array ( tsvector ) → text[]
changedunnest
--- 9.5 +++ 9.6 @@ -1,2 +1,3 @@ +unnest ( tsvector, OUT lexeme text, OUT positions smallint[], OUT weights text ) → setof record unnest ( anyarray ) → setof anyelement unnest ( anyarray, anyarray [, ...] ) → setof anyelement, anyelement [, ...]
addedjsonb_insert
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +jsonb_insert ( target jsonb, path text[], new_value jsonb [, insert_after boolean] ) → jsonb
addedpg_blocking_pids
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +pg_blocking_pids ( int ) → int[]
addedpg_control_checkpoint
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +pg_control_checkpoint ( ) → record
addedpg_control_init
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +pg_control_init ( ) → record
addedpg_control_recovery
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +pg_control_recovery ( ) → record
addedpg_control_system
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +pg_control_system ( ) → record
addedpg_index_column_has_property
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +pg_index_column_has_property ( index_oid, column_no, prop_name ) → boolean
addedpg_index_has_property
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +pg_index_has_property ( index_oid, prop_name ) → boolean
addedpg_indexam_has_property
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +pg_indexam_has_property ( am_oid, prop_name ) → boolean
addedpg_notification_queue_usage
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +pg_notification_queue_usage ( ) → double
changedbrin_summarize_new_values
--- 9.5 +++ 9.6 @@ -1 +1 @@ -brin_summarize_new_values ( index_oid regclass ) → integer +brin_summarize_new_values ( index regclass ) → integer
changedcurrent_setting
--- 9.5 +++ 9.6 @@ -1 +1 @@ -current_setting ( setting_name ) → text +current_setting ( setting_name [, missing_ok ] ) → text
addedgin_clean_pending_list
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +gin_clean_pending_list ( index regclass ) → bigint
changedpg_create_physical_replication_slot
--- 9.5 +++ 9.6 @@ -1 +1 @@ -pg_create_physical_replication_slot ( slot_name name ) → (slot_name name, xlog_position pg_lsn) +pg_create_physical_replication_slot ( slot_name name [, immediately_reserve boolean ] ) → (slot_name name, xlog_position pg_lsn)
addedpg_current_xlog_flush_location
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +pg_current_xlog_flush_location ( ) → pg_lsn
addedpg_logical_emit_message
--- 9.5 +++ 9.6 @@ -0,0 +1,2 @@ +pg_logical_emit_message ( transactional bool, prefix text, content text ) → pg_lsn +pg_logical_emit_message ( transactional bool, prefix text, content bytea ) → pg_lsn
changedpg_replication_origin_xact_reset
--- 9.5 +++ 9.6 @@ -1 +1 @@ -pg_replication_origin_xact_reset ( origin_lsn pg_lsn, origin_timestamp timestamptz ) → void +pg_replication_origin_xact_reset ( ) → void
addedpg_size_bytes
--- 9.5 +++ 9.6 @@ -0,0 +1 @@ +pg_size_bytes ( text ) → bigint
changedpg_start_backup
--- 9.5 +++ 9.6 @@ -1 +1 @@ -pg_start_backup ( label text [, fast boolean ] ) → pg_lsn +pg_start_backup ( label text [, fast boolean [, exclusive boolean ]] ) → pg_lsn
changedpg_stop_backup
--- 9.5 +++ 9.6 @@ -1 +1,2 @@ pg_stop_backup ( ) → pg_lsn +pg_stop_backup ( exclusive boolean ) → setof record