FUNCTIONS / VERSION COMPARISON
What changed?
Functions · PostgreSQL 17 → 18
18 added · 0 removed · 8 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
addedgamma
--- 17 +++ 18 @@ -0,0 +1 @@ +gamma ( double precision ) → double precision
addedlgamma
--- 17 +++ 18 @@ -0,0 +1 @@ +lgamma ( double precision ) → double precision
addedcasefold
--- 17 +++ 18 @@ -0,0 +1 @@ +casefold ( text ) → text
changedregexp_replace
--- 17 +++ 18 @@ -1,2 +1,2 @@ -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 +regexp_replace ( string text, pattern text, replacement text [, flags text ] ) → text +regexp_replace ( string text, pattern text, replacement text, start integer [, N integer [, flags text ] ] ) → text
changedreverse
--- 17 +++ 18 @@ -1 +1,2 @@ reverse ( text ) → text +reverse ( bytea ) → bytea
addedcrc32
--- 17 +++ 18 @@ -0,0 +1 @@ +crc32 ( bytea ) → bigint
addedcrc32c
--- 17 +++ 18 @@ -0,0 +1 @@ +crc32c ( bytea ) → bigint
changeddate_trunc
--- 17 +++ 18 @@ -1,4 +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 [, time_zone ]) +date_trunc(field, source [, time_zone])
changedgen_random_uuid
--- 17 +++ 18 @@ -1 +1 @@ -gen_random_uuid () → uuid +gen_random_uuid ( ) → uuid
changeduuid_extract_timestamp
--- 17 +++ 18 @@ -1 +1 @@ -uuid_extract_timestamp (uuid) → timestamp with time zone +uuid_extract_timestamp ( uuid ) → timestamp with time zone
changeduuid_extract_version
--- 17 +++ 18 @@ -1 +1 @@ -uuid_extract_version (uuid) → smallint +uuid_extract_version ( uuid ) → smallint
addeduuidv4
--- 17 +++ 18 @@ -0,0 +1 @@ +uuidv4 ( ) → uuid
addeduuidv7
--- 17 +++ 18 @@ -0,0 +1 @@ +uuidv7 ( [ shift interval ] ) → uuid
changedjson_strip_nulls
--- 17 +++ 18 @@ -1 +1 @@ -json_strip_nulls ( json ) → json +json_strip_nulls ( target json [,strip_in_arrays boolean ] ) → json
changedjsonb_strip_nulls
--- 17 +++ 18 @@ -1 +1 @@ -jsonb_strip_nulls ( jsonb ) → jsonb +jsonb_strip_nulls ( target jsonb [,strip_in_arrays boolean ] ) → jsonb
addedarray_reverse
--- 17 +++ 18 @@ -0,0 +1 @@ +array_reverse ( anyarray ) → anyarray
addedarray_sort
--- 17 +++ 18 @@ -0,0 +1 @@ +array_sort ( array anyarray [, descending boolean [, nulls_first boolean ]] ) → anyarray
addedhas_largeobject_privilege
--- 17 +++ 18 @@ -0,0 +1 @@ +has_largeobject_privilege ( [ user name or oid, ] largeobject oid, privilege text ) → boolean
addedpg_get_acl
--- 17 +++ 18 @@ -0,0 +1 @@ +pg_get_acl ( classid oid, objid oid, objsubid integer ) → aclitem[]
addedpg_get_loaded_modules
--- 17 +++ 18 @@ -0,0 +1 @@ +pg_get_loaded_modules () → setof record ( module_name text, version text, file_name text )
addedpg_numa_available
--- 17 +++ 18 @@ -0,0 +1 @@ +pg_numa_available () → boolean
addedpg_clear_attribute_stats
--- 17 +++ 18 @@ -0,0 +1 @@ +pg_clear_attribute_stats ( schemaname text, relname text, attname text, inherited boolean ) → void
addedpg_clear_relation_stats
--- 17 +++ 18 @@ -0,0 +1 @@ +pg_clear_relation_stats ( schemaname text, relname text ) → void
addedpg_ls_summariesdir
--- 17 +++ 18 @@ -0,0 +1 @@ +pg_ls_summariesdir () → setof record ( name text, size bigint, modification timestamp with time zone )
addedpg_restore_attribute_stats
--- 17 +++ 18 @@ -0,0 +1 @@ +pg_restore_attribute_stats ( VARIADIC kwargs "any" ) → boolean
addedpg_restore_relation_stats
--- 17 +++ 18 @@ -0,0 +1 @@ +pg_restore_relation_stats ( VARIADIC kwargs "any" ) → boolean