Skip to content

feat(expr): PostgreSQL 18 new expressions #23368

@xiangjinwu

Description

@xiangjinwu

https://www.postgresql.org/docs/18/release-18.html#RELEASE-18-DATATYPES

  • jsonb
    • jsonb null cast to sql null
    • json_strip_nulls for null array elements
  • array
    • array_sort ( array anyarray [, descending boolean [, nulls_first boolean ]] ) → anyarray
    • array_reverse ( anyarray ) → anyarray
  • bytea
    • reverse ( bytea ) → bytea
    • explicit cast int2/4/8 <-> bytea
    • crc32 ( bytea ) → bigint
    • crc32c ( bytea ) → bigint
  • unicode text
    • casefold ( text ) → text
  • math
    • gamma ( double precision ) → double precision
    • lgamma ( double precision ) → double precision

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-exprArea: Scalar function, operator, expression framework.P-lowPriority: Low.good first issueGood for newcomerstype/featureType: New feature.

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions