Functions / Version comparison

What changed?

Functions · PostgreSQL 19 beta 4 → 20 devel

Development snapshot. These definitions may change before release.

6 added · 0 removed · 2 changed. These are changes between the pinned reference snapshots.

--- 19 beta 4
+++ 20 devel
@@ -0,0 +1 @@
+getdatabaseencoding ( ) → name

changedJSON_TABLE

--- 19 beta 4
+++ 20 devel
@@ -1 +1 @@
-JSON_TABLE ( context_item, path_expression [ AS json_path_name] [ PASSING { value AS varname } [, ...] ] COLUMNS ( json_table_column [, ...] ) [ { ERROR | EMPTY [ARRAY]} ON ERROR] )
+JSON_TABLE ( context_item, path_expression [ AS json_path_name] [ PASSING { value AS varname } [, ...] ] COLUMNS ( json_table_column [, ...] ) [ PLAN ( json_table_plan ) | PLAN DEFAULT ( { OUTER | INNER } [ , { CROSS | UNION } ] | { CROSS | UNION } [ , { OUTER | INNER } ] ) ] [ { ERROR | EMPTY [ARRAY]} ON ERROR] )

addedpg_get_database_ddl

--- 19 beta 4
+++ 20 devel
@@ -0,0 +1 @@
+pg_get_database_ddl ( database regdatabase [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] [, tablespace boolean DEFAULT true] ) → setof text

addedpg_get_role_ddl

--- 19 beta 4
+++ 20 devel
@@ -0,0 +1 @@
+pg_get_role_ddl ( role regrole [, pretty boolean DEFAULT false] [, memberships boolean DEFAULT true] ) → setof text

addedpg_get_tablespace_ddl

--- 19 beta 4
+++ 20 devel
@@ -0,0 +1,2 @@
+pg_get_tablespace_ddl ( tablespace oid [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text
+pg_get_tablespace_ddl ( tablespace name [, pretty boolean DEFAULT false] [, owner boolean DEFAULT true] ) → setof text

changedpg_column_toast_chunk_id

--- 19 beta 4
+++ 20 devel
@@ -1 +1 @@
-pg_column_toast_chunk_id ( "any" ) → oid
+pg_column_toast_chunk_id ( "any" ) → oid8

addedpg_disable_data_checksums

--- 19 beta 4
+++ 20 devel
@@ -0,0 +1 @@
+pg_disable_data_checksums () → void

addedpg_enable_data_checksums

--- 19 beta 4
+++ 20 devel
@@ -0,0 +1 @@
+pg_enable_data_checksums ( [cost_delay int [, cost_limit int]] ) → void