FUNCTIONS / VERSION COMPARISON
What changed?
Functions · PostgreSQL 12 → 13
Historical documentation for a PostgreSQL version that is no longer supported.
PostgreSQL 13 reorganized the function documentation. This comparison lists additions and removals; signature formatting differences across this boundary are omitted.
27 added · 1 removed · 0 changed · 0 coverage changes. These are changes in the pinned reference snapshots.
addedgcd
--- 12 +++ 13 @@ -0,0 +1 @@ +gcd ( numeric_type, numeric_type ) → numeric_type
addedlcm
--- 12 +++ 13 @@ -0,0 +1 @@ +lcm ( numeric_type, numeric_type ) → numeric_type
addedmin_scale
--- 12 +++ 13 @@ -0,0 +1 @@ +min_scale ( numeric ) → integer
addedtrim_scale
--- 12 +++ 13 @@ -0,0 +1 @@ +trim_scale ( numeric ) → numeric
addednormalize
--- 12 +++ 13 @@ -0,0 +1 @@ +normalize ( text [, form ] ) → text
addeddiagonal
--- 12 +++ 13 @@ -0,0 +1 @@ +diagonal ( box ) → lseg
addedslope
--- 12 +++ 13 @@ -0,0 +1 @@ +slope ( point, point ) → double precision
addedjson_to_tsvector
--- 12 +++ 13 @@ -0,0 +1 @@ +json_to_tsvector ( [ config regconfig, ] document json, filter jsonb ) → tsvector
addedjsonb_to_tsvector
--- 12 +++ 13 @@ -0,0 +1 @@ +jsonb_to_tsvector ( [ config regconfig, ] document jsonb, filter jsonb ) → tsvector
addedgen_random_uuid
--- 12 +++ 13 @@ -0,0 +1 @@ +gen_random_uuid () → uuid
removedjson
--- 12 +++ 13 @@ -1 +0,0 @@ -json ( b ) _to_tsvector([ config regconfig, ] document json(b), filter json(b)) → tsvector
addedjsonb_path_exists_tz
--- 12 +++ 13 @@ -0,0 +1 @@ +jsonb_path_exists_tz ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → boolean
addedjsonb_path_match_tz
--- 12 +++ 13 @@ -0,0 +1 @@ +jsonb_path_match_tz ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → boolean
addedjsonb_path_query_array_tz
--- 12 +++ 13 @@ -0,0 +1 @@ +jsonb_path_query_array_tz ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → jsonb
addedjsonb_path_query_first_tz
--- 12 +++ 13 @@ -0,0 +1 @@ +jsonb_path_query_first_tz ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → jsonb
addedjsonb_path_query_tz
--- 12 +++ 13 @@ -0,0 +1 @@ +jsonb_path_query_tz ( target jsonb, path jsonpath [, vars jsonb [, silent boolean ]] ) → setof jsonb
addedjsonb_set_lax
--- 12 +++ 13 @@ -0,0 +1 @@ +jsonb_set_lax ( target jsonb, path text[], new_value jsonb [, create_if_missing boolean [, null_value_treatment text ]] ) → jsonb
addedmxid_age
--- 12 +++ 13 @@ -0,0 +1 @@ +mxid_age ( xid ) → integer
addedpg_current_snapshot
--- 12 +++ 13 @@ -0,0 +1 @@ +pg_current_snapshot () → pg_snapshot
addedpg_current_xact_id
--- 12 +++ 13 @@ -0,0 +1 @@ +pg_current_xact_id () → xid8
addedpg_current_xact_id_if_assigned
--- 12 +++ 13 @@ -0,0 +1 @@ +pg_current_xact_id_if_assigned () → xid8
addedpg_get_multixact_members
--- 12 +++ 13 @@ -0,0 +1 @@ +pg_get_multixact_members ( multixid xid ) → setof record ( xid xid, mode text )
addedpg_snapshot_xip
--- 12 +++ 13 @@ -0,0 +1 @@ +pg_snapshot_xip ( pg_snapshot ) → setof xid8
addedpg_snapshot_xmax
--- 12 +++ 13 @@ -0,0 +1 @@ +pg_snapshot_xmax ( pg_snapshot ) → xid8
addedpg_snapshot_xmin
--- 12 +++ 13 @@ -0,0 +1 @@ +pg_snapshot_xmin ( pg_snapshot ) → xid8
addedpg_visible_in_snapshot
--- 12 +++ 13 @@ -0,0 +1 @@ +pg_visible_in_snapshot ( xid8, pg_snapshot ) → boolean
addedpg_xact_status
--- 12 +++ 13 @@ -0,0 +1 @@ +pg_xact_status ( xid8 ) → text
addedto_regcollation
--- 12 +++ 13 @@ -0,0 +1 @@ +to_regcollation ( text ) → regcollation