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 14 → 15

Browse PG 15 →

15 added · 4 removed · 2 changed · 0 coverage changes. These are changes in the pinned reference snapshots.

addedregexp_count
--- 14
+++ 15
@@ -0,0 +1 @@
+regexp_count ( string text, pattern text [, start integer [, flags text ] ] ) → integer
addedregexp_instr
--- 14
+++ 15
@@ -0,0 +1 @@
+regexp_instr ( string text, pattern text [, start integer [, N integer [, endoption integer [, flags text [, subexpr integer ] ] ] ] ] ) → integer
addedregexp_like
--- 14
+++ 15
@@ -0,0 +1 @@
+regexp_like ( string text, pattern text [, flags text ] ) → boolean
changedregexp_replace
--- 14
+++ 15
@@ -1 +1,2 @@
-regexp_replace ( string text, pattern text, replacement text [, flags text ] ) → text
+regexp_replace ( string text, pattern text, replacement text [, start integer ] [, flags text ] ) → text
+regexp_replace ( string text, pattern text, replacement text, start integer, N integer [, flags text ] ) → text
addedregexp_substr
--- 14
+++ 15
@@ -0,0 +1 @@
+regexp_substr ( string text, pattern text [, start integer [, N integer [, flags text [, subexpr integer ] ] ] ] ) → text
changedrange_agg
--- 14
+++ 15
@@ -1 +1,2 @@
 range_agg ( value anyrange ) → anymultirange
+range_agg ( value anymultirange ) → anymultirange
addedhas_parameter_privilege
--- 14
+++ 15
@@ -0,0 +1 @@
+has_parameter_privilege ( [ user name or oid, ] parameter text, privilege text ) → boolean
addedpg_char_to_encoding
--- 14
+++ 15
@@ -0,0 +1 @@
+pg_char_to_encoding ( encoding name ) → integer
addedpg_encoding_to_char
--- 14
+++ 15
@@ -0,0 +1 @@
+pg_encoding_to_char ( encoding integer ) → name
addedpg_settings_get_flags
--- 14
+++ 15
@@ -0,0 +1 @@
+pg_settings_get_flags ( guc text ) → text[]
addedpg_backup_start
--- 14
+++ 15
@@ -0,0 +1 @@
+pg_backup_start ( label text [, fast boolean ] ) → pg_lsn
removedpg_backup_start_time
--- 14
+++ 15
@@ -1 +0,0 @@
-pg_backup_start_time () → timestamp with time zone
addedpg_backup_stop
--- 14
+++ 15
@@ -0,0 +1 @@
+pg_backup_stop ( [wait_for_archive boolean ] ) → record ( lsn pg_lsn, labelfile text, spcmapfile text )
addedpg_database_collation_actual_version
--- 14
+++ 15
@@ -0,0 +1 @@
+pg_database_collation_actual_version ( oid ) → text
addedpg_get_wal_resource_managers
--- 14
+++ 15
@@ -0,0 +1 @@
+pg_get_wal_resource_managers () → setof record ( rm_id integer, rm_name text, rm_builtin boolean )
removedpg_is_in_backup
--- 14
+++ 15
@@ -1 +0,0 @@
-pg_is_in_backup () → boolean
addedpg_ls_logicalmapdir
--- 14
+++ 15
@@ -0,0 +1 @@
+pg_ls_logicalmapdir () → setof record ( name text, size bigint, modification timestamp with time zone )
addedpg_ls_logicalsnapdir
--- 14
+++ 15
@@ -0,0 +1 @@
+pg_ls_logicalsnapdir () → setof record ( name text, size bigint, modification timestamp with time zone )
addedpg_ls_replslotdir
--- 14
+++ 15
@@ -0,0 +1 @@
+pg_ls_replslotdir ( slot_name text ) → setof record ( name text, size bigint, modification timestamp with time zone )
removedpg_start_backup
--- 14
+++ 15
@@ -1 +0,0 @@
-pg_start_backup ( label text [, fast boolean [, exclusive boolean ]] ) → pg_lsn
removedpg_stop_backup
--- 14
+++ 15
@@ -1,2 +0,0 @@
-pg_stop_backup ( exclusive boolean [, wait_for_archive boolean ] ) → setof record ( lsn pg_lsn, labelfile text, spcmapfile text )
-pg_stop_backup () → pg_lsn