]> granicus.if.org Git - postgresql/commit
Create real array comparison functions (that use the element datatype's
authorTom Lane <tgl@sss.pgh.pa.us>
Fri, 27 Jun 2003 00:33:26 +0000 (00:33 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Fri, 27 Jun 2003 00:33:26 +0000 (00:33 +0000)
commitb3c0551edaf390ab7bde4ebcc2299d1b0da686c5
tree46512d8ab2d8eeb570722878904f367effb1383d
parent0c985ab5a86b4ca9d8e312bfd0db5536b2be121e
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).
28 files changed:
doc/src/sgml/array.sgml
doc/src/sgml/func.sgml
src/backend/executor/execQual.c
src/backend/executor/nodeSubplan.c
src/backend/parser/parse_coerce.c
src/backend/parser/parse_expr.c
src/backend/parser/parse_oper.c
src/backend/utils/adt/acl.c
src/backend/utils/adt/array_userfuncs.c
src/backend/utils/adt/arrayfuncs.c
src/backend/utils/adt/varlena.c
src/backend/utils/cache/lsyscache.c
src/include/catalog/catversion.h
src/include/catalog/pg_amop.h
src/include/catalog/pg_amproc.h
src/include/catalog/pg_opclass.h
src/include/catalog/pg_operator.h
src/include/catalog/pg_proc.h
src/include/parser/parse_oper.h
src/include/utils/acl.h
src/include/utils/array.h
src/include/utils/builtins.h
src/include/utils/lsyscache.h
src/interfaces/ecpg/preproc/preproc.y
src/interfaces/ecpg/preproc/type.c
src/interfaces/ecpg/preproc/variable.c
src/test/regress/expected/arrays.out
src/test/regress/sql/arrays.sql