↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

FUNCTIONS / VERSION COMPARISON

What changed?

Functions · PostgreSQL 9.6 → 10

Browse PG 10 →

Historical documentation for a PostgreSQL version that is no longer supported.

27 added · 12 removed · 11 changed · 0 coverage changes. These are changes in the pinned reference snapshots.

changedtrunc
--- 9.6
+++ 10
@@ -1,3 +1,4 @@
 trunc ( dp or numeric ) → (same as input)
 trunc ( v numeric, s int ) → numeric
 trunc ( macaddr ) → macaddr
+trunc ( macaddr8 ) → macaddr8
addedregexp_match
--- 9.6
+++ 10
@@ -0,0 +1 @@
+regexp_match ( string text, pattern text [, flags text] ) → text[]
addedmacaddr8_set7bit
--- 9.6
+++ 10
@@ -0,0 +1 @@
+macaddr8_set7bit ( macaddr8 ) → macaddr8
changedto_tsvector
--- 9.6
+++ 10
@@ -1 +1,2 @@
 to_tsvector ( [ config regconfig , ] document text ) → tsvector
+to_tsvector ( [ config regconfig , ] document json(b) ) → tsvector
changedts_headline
--- 9.6
+++ 10
@@ -1 +1,2 @@
 ts_headline ( [ config regconfig, ] document text, query tsquery [, options text ] ) → text
+ts_headline ( [ config regconfig, ] document json(b), query tsquery [, options text ] ) → text
addedXMLTABLE
--- 9.6
+++ 10
@@ -0,0 +1 @@
+xmltable( [XMLNAMESPACES(namespace uri AS namespace name[, ...]), ] row_expression PASSING [BY REF] document_expression [BY REF] COLUMNS name { type [PATH column_expression] [DEFAULT default_expression] [NOT NULL | NULL] | FOR ORDINALITY } [, ...] )
addedpg_current_logfile
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_current_logfile ( [text] ) → text
addedpg_get_statisticsobjdef
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_get_statisticsobjdef ( statobj_oid ) → text
addedpg_safe_snapshot_blocking_pids
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_safe_snapshot_blocking_pids ( int ) → int[]
addedpg_statistics_obj_is_visible
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_statistics_obj_is_visible ( stat_oid ) → boolean
addedtxid_current_if_assigned
--- 9.6
+++ 10
@@ -0,0 +1 @@
+txid_current_if_assigned ( ) → bigint
addedtxid_status
--- 9.6
+++ 10
@@ -0,0 +1 @@
+txid_status ( bigint ) → text
addedbrin_desummarize_range
--- 9.6
+++ 10
@@ -0,0 +1 @@
+brin_desummarize_range ( index regclass, blockNumber bigint ) → integer
addedbrin_summarize_range
--- 9.6
+++ 10
@@ -0,0 +1 @@
+brin_summarize_range ( index regclass, blockNumber bigint ) → integer
addedpg_collation_actual_version
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_collation_actual_version ( oid ) → text
changedpg_create_logical_replication_slot
--- 9.6
+++ 10
@@ -1 +1 @@
-pg_create_logical_replication_slot ( slot_name name, plugin name ) → (slot_name name, xlog_position pg_lsn)
+pg_create_logical_replication_slot ( slot_name name, plugin name [, temporary boolean] ) → (slot_name name, lsn pg_lsn)
changedpg_create_physical_replication_slot
--- 9.6
+++ 10
@@ -1 +1 @@
-pg_create_physical_replication_slot ( slot_name name [, immediately_reserve boolean ] ) → (slot_name name, xlog_position pg_lsn)
+pg_create_physical_replication_slot ( slot_name name [, immediately_reserve boolean, temporary boolean] ) → (slot_name name, lsn pg_lsn)
addedpg_current_wal_flush_lsn
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_current_wal_flush_lsn ( ) → pg_lsn
addedpg_current_wal_insert_lsn
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_current_wal_insert_lsn ( ) → pg_lsn
addedpg_current_wal_lsn
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_current_wal_lsn ( ) → pg_lsn
removedpg_current_xlog_flush_location
--- 9.6
+++ 10
@@ -1 +0,0 @@
-pg_current_xlog_flush_location ( ) → pg_lsn
removedpg_current_xlog_insert_location
--- 9.6
+++ 10
@@ -1 +0,0 @@
-pg_current_xlog_insert_location ( ) → pg_lsn
removedpg_current_xlog_location
--- 9.6
+++ 10
@@ -1 +0,0 @@
-pg_current_xlog_location ( ) → pg_lsn
addedpg_import_system_collations
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_import_system_collations ( schema regnamespace ) → integer
addedpg_is_wal_replay_paused
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_is_wal_replay_paused ( ) → bool
removedpg_is_xlog_replay_paused
--- 9.6
+++ 10
@@ -1 +0,0 @@
-pg_is_xlog_replay_paused ( ) → bool
addedpg_last_wal_receive_lsn
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_last_wal_receive_lsn ( ) → pg_lsn
addedpg_last_wal_replay_lsn
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_last_wal_replay_lsn ( ) → pg_lsn
removedpg_last_xlog_receive_location
--- 9.6
+++ 10
@@ -1 +0,0 @@
-pg_last_xlog_receive_location ( ) → pg_lsn
removedpg_last_xlog_replay_location
--- 9.6
+++ 10
@@ -1 +0,0 @@
-pg_last_xlog_replay_location ( ) → pg_lsn
changedpg_logical_slot_get_binary_changes
--- 9.6
+++ 10
@@ -1 +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)
+pg_logical_slot_get_binary_changes ( slot_name name, upto_lsn pg_lsn, upto_nchanges int, VARIADIC options text[] ) → (lsn pg_lsn, xid xid, data bytea)
changedpg_logical_slot_get_changes
--- 9.6
+++ 10
@@ -1 +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)
+pg_logical_slot_get_changes ( slot_name name, upto_lsn pg_lsn, upto_nchanges int, VARIADIC options text[] ) → (lsn pg_lsn, xid xid, data text)
changedpg_logical_slot_peek_binary_changes
--- 9.6
+++ 10
@@ -1 +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)
+pg_logical_slot_peek_binary_changes ( slot_name name, upto_lsn pg_lsn, upto_nchanges int, VARIADIC options text[] ) → (lsn pg_lsn, xid xid, data bytea)
changedpg_logical_slot_peek_changes
--- 9.6
+++ 10
@@ -1 +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)
+pg_logical_slot_peek_changes ( slot_name name, upto_lsn pg_lsn, upto_nchanges int, VARIADIC options text[] ) → (lsn pg_lsn, xid xid, data text)
addedpg_ls_logdir
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_ls_logdir ( ) → setof record
addedpg_ls_waldir
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_ls_waldir ( ) → setof record
changedpg_replication_origin_advance
--- 9.6
+++ 10
@@ -1 +1 @@
-pg_replication_origin_advance ( node_name text, pos pg_lsn ) → void
+pg_replication_origin_advance ( node_name text, lsn pg_lsn ) → void
changedpg_stop_backup
--- 9.6
+++ 10
@@ -1,2 +1,2 @@
 pg_stop_backup ( ) → pg_lsn
-pg_stop_backup ( exclusive boolean ) → setof record
+pg_stop_backup ( exclusive boolean [, wait_for_archive boolean ] ) → setof record
addedpg_switch_wal
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_switch_wal ( ) → pg_lsn
removedpg_switch_xlog
--- 9.6
+++ 10
@@ -1 +0,0 @@
-pg_switch_xlog ( ) → pg_lsn
addedpg_wal_lsn_diff
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_wal_lsn_diff ( lsn pg_lsn, lsn pg_lsn ) → numeric
addedpg_wal_replay_pause
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_wal_replay_pause ( ) → void
addedpg_wal_replay_resume
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_wal_replay_resume ( ) → void
addedpg_walfile_name
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_walfile_name ( lsn pg_lsn ) → text
addedpg_walfile_name_offset
--- 9.6
+++ 10
@@ -0,0 +1 @@
+pg_walfile_name_offset ( lsn pg_lsn ) → text, integer
removedpg_xlog_location_diff
--- 9.6
+++ 10
@@ -1 +0,0 @@
-pg_xlog_location_diff ( location pg_lsn, location pg_lsn ) → numeric
removedpg_xlog_replay_pause
--- 9.6
+++ 10
@@ -1 +0,0 @@
-pg_xlog_replay_pause ( ) → void
removedpg_xlog_replay_resume
--- 9.6
+++ 10
@@ -1 +0,0 @@
-pg_xlog_replay_resume ( ) → void
removedpg_xlogfile_name
--- 9.6
+++ 10
@@ -1 +0,0 @@
-pg_xlogfile_name ( location pg_lsn ) → text
removedpg_xlogfile_name_offset
--- 9.6
+++ 10
@@ -1 +0,0 @@
-pg_xlogfile_name_offset ( location pg_lsn ) → text, integer