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 10 → 11

Browse PG 11 →

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

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

addedstarts_with
--- 10
+++ 11
@@ -0,0 +1 @@
+starts_with ( string, prefix ) → bool
addedsha224
--- 10
+++ 11
@@ -0,0 +1 @@
+sha224 ( bytea ) → bytea
addedsha256
--- 10
+++ 11
@@ -0,0 +1 @@
+sha256 ( bytea ) → bytea
addedsha384
--- 10
+++ 11
@@ -0,0 +1 @@
+sha384 ( bytea ) → bytea
addedsha512
--- 10
+++ 11
@@ -0,0 +1 @@
+sha512 ( bytea ) → bytea
addedwebsearch_to_tsquery
--- 10
+++ 11
@@ -0,0 +1 @@
+websearch_to_tsquery ( [ config regconfig , ] query text ) → tsquery
addedjson
--- 10
+++ 11
@@ -0,0 +1 @@
+json ( b ) _to_tsvector([ config regconfig, ] document json(b), filter json(b)) → tsvector
changedpg_get_object_address
--- 10
+++ 11
@@ -1 +1 @@
-pg_get_object_address ( type text, name text[], args text[] ) → classid oid, objid oid, objsubid integer
+pg_get_object_address ( type text, object_names text[], object_args text[] ) → classid oid, objid oid, objsubid integer
addedpg_jit_available
--- 10
+++ 11
@@ -0,0 +1 @@
+pg_jit_available ( ) → boolean
addedpg_replication_slot_advance
--- 10
+++ 11
@@ -0,0 +1 @@
+pg_replication_slot_advance ( slot_name name, upto_lsn pg_lsn ) → (slot_name name, end_lsn pg_lsn) bool