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 19 beta 3 → 20 devel

Browse PG 20 →

Development snapshot. These definitions may change before release.

1 added · 1 removed · 1 changed · 0 coverage changes. These are changes in the pinned reference snapshots.

addedgetdatabaseencoding
--- 19 beta 3
+++ 20 devel
@@ -0,0 +1 @@
+getdatabaseencoding ( ) → name
changedJSON_TABLE
--- 19 beta 3
+++ 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] )
removedpg_get_propgraphdef
--- 19 beta 3
+++ 20 devel
@@ -1 +0,0 @@
-pg_get_propgraphdef ( propgraph oid ) → text