FUNCTIONS / VERSION COMPARISON
What changed?
Functions · PostgreSQL 11 → 12
Historical documentation for a PostgreSQL version that is no longer supported.
24 added · 0 removed · 4 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
addedacosh
--- 11 +++ 12 @@ -0,0 +1 @@ +acosh ( x )
addedasinh
--- 11 +++ 12 @@ -0,0 +1 @@ +asinh ( x )
addedatanh
--- 11 +++ 12 @@ -0,0 +1 @@ +atanh ( x )
addedcosh
--- 11 +++ 12 @@ -0,0 +1 @@ +cosh ( x )
addedlog10
--- 11 +++ 12 @@ -0,0 +1 @@ +log10 ( dp or numeric ) → (same as input)
addedsinh
--- 11 +++ 12 @@ -0,0 +1 @@ +sinh ( x )
addedtanh
--- 11 +++ 12 @@ -0,0 +1 @@ +tanh ( x )
changedsubstring
--- 11 +++ 12 @@ -2,3 +2,5 @@ substring ( string from pattern ) → text substring ( string from pattern for escape ) → text substring ( string [from int] [for int] ) → bytea +substring(string from pattern for escape-character) +substring(string, pattern, escape-character)
changeddate_trunc
--- 11
+++ 12
@@ -1,3 +1,4 @@
date_trunc ( text, timestamp ) → timestamp
+date_trunc ( text, timestamp with time zone, text ) → timestamp with time zone
date_trunc ( text, interval ) → interval
-date_trunc('field', source)
+date_trunc(field, source [, time_zone ])changedXMLEXISTS
--- 11
+++ 12
@@ -1 +1 @@
-XMLEXISTS(text PASSING [BY REF] xml [BY REF])
+XMLEXISTS(text PASSING [BY { REF | VALUE }] xml [BY { REF | VALUE }])changedXMLTABLE
--- 11
+++ 12
@@ -1 +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 } [, ...] )
+xmltable( [XMLNAMESPACES(namespace uri AS namespace name[, ...]), ] row_expression PASSING [BY { REF | VALUE }] document_expression [BY { REF | VALUE }] COLUMNS name { type [PATH column_expression] [DEFAULT default_expression] [NOT NULL | NULL] | FOR ORDINALITY } [, ...] )addedjsonb_path_exists
--- 11 +++ 12 @@ -0,0 +1 @@ +jsonb_path_exists ( target jsonb, path jsonpath [, vars jsonb [, silent bool]] ) → boolean
addedjsonb_path_match
--- 11 +++ 12 @@ -0,0 +1 @@ +jsonb_path_match ( target jsonb, path jsonpath [, vars jsonb [, silent bool]] ) → boolean
addedjsonb_path_query
--- 11 +++ 12 @@ -0,0 +1 @@ +jsonb_path_query ( target jsonb, path jsonpath [, vars jsonb [, silent bool]] ) → setof jsonb
addedjsonb_path_query_array
--- 11 +++ 12 @@ -0,0 +1 @@ +jsonb_path_query_array ( target jsonb, path jsonpath [, vars jsonb [, silent bool]] ) → jsonb
addedjsonb_path_query_first
--- 11 +++ 12 @@ -0,0 +1 @@ +jsonb_path_query_first ( target jsonb, path jsonpath [, vars jsonb [, silent bool]] ) → jsonb
addedacldefault
--- 11 +++ 12 @@ -0,0 +1 @@ +acldefault ( type, ownerId ) → aclitem[]
addedaclexplode
--- 11 +++ 12 @@ -0,0 +1 @@ +aclexplode ( aclitem[] ) → setof record
addedmakeaclitem
--- 11 +++ 12 @@ -0,0 +1 @@ +makeaclitem ( grantee, grantor, privilege, grantable ) → aclitem
addedpg_copy_logical_replication_slot
--- 11 +++ 12 @@ -0,0 +1 @@ +pg_copy_logical_replication_slot ( src_slot_name name, dst_slot_name name [, temporary boolean [, plugin name]] ) → (slot_name name, lsn pg_lsn)
addedpg_copy_physical_replication_slot
--- 11 +++ 12 @@ -0,0 +1 @@ +pg_copy_physical_replication_slot ( src_slot_name name, dst_slot_name name [, temporary boolean] ) → (slot_name name, lsn pg_lsn)
addedpg_ls_archive_statusdir
--- 11 +++ 12 @@ -0,0 +1 @@ +pg_ls_archive_statusdir ( ) → setof record
addedpg_ls_tmpdir
--- 11 +++ 12 @@ -0,0 +1 @@ +pg_ls_tmpdir ( [tablespace oid] ) → setof record
addedpg_partition_ancestors
--- 11 +++ 12 @@ -0,0 +1 @@ +pg_partition_ancestors ( regclass ) → setof regclass
addedpg_partition_root
--- 11 +++ 12 @@ -0,0 +1 @@ +pg_partition_root ( regclass ) → regclass
addedpg_partition_tree
--- 11 +++ 12 @@ -0,0 +1 @@ +pg_partition_tree ( regclass ) → setof record
addedpg_promote
--- 11 +++ 12 @@ -0,0 +1 @@ +pg_promote ( wait boolean DEFAULT true, wait_seconds integer DEFAULT 60 ) → boolean