pgsql-server/ oc/src/sgml/array.sgml oc/src/sg ...

CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    tgl@svr1.postgresql.org    03/06/26 21:33:26

Modified files:
    doc/src/sgml   : array.sgml func.sgml
    src/backend/executor: execQual.c nodeSubplan.c
    src/backend/parser: parse_coerce.c parse_expr.c parse_oper.c
    src/backend/utils/adt: acl.c array_userfuncs.c arrayfuncs.c
                           varlena.c
    src/backend/utils/cache: lsyscache.c
    src/include/catalog: catversion.h pg_amop.h pg_amproc.h
                         pg_opclass.h pg_operator.h pg_proc.h
    src/include/parser: parse_oper.h
    src/include/utils: acl.h array.h builtins.h lsyscache.h
    src/interfaces/ecpg/preproc: preproc.y type.c variable.c
    src/test/regress/expected: arrays.out
    src/test/regress/sql: arrays.sql

Log message:
    Create real array comparison functions (that use the element datatype's
    comparison functions), replacing the highly bogus bitwise array_eq.  Create
    a btree index opclass for ANYARRAY --- it is now possible to create indexes
    on array columns.
    Arrange to cache the results of catalog lookups across multiple array
    operations, instead of repeating the lookups on every call.
    Add string_to_array and array_to_string functions.
    Remove singleton_array, array_accum, array_assign, and array_subscript
    functions, since these were for proof-of-concept and not intended to become
    supported functions.
    Minor adjustments to behavior in some corner cases with empty or
    zero-dimensional arrays.

    Joe Conway (with some editorializing by Tom Lane).