Re: array support patch phase 1 patch

Joe Conway writes:

>     select ARRAY[1,2,3];
>     select ARRAY[[1,2,3],[4,5,6]];
>     select ARRAY[ARRAY[1,2,3],ARRAY[4,5,6]];
>     ...etc up to 6 dimensions

Why only 6?

> 4. Duplicated contrib/array functionality (and then some) in the
>     backend using polymorphic functions and operators.

>     SELECT ARRAY[1,2,3] *= 2 AS "TRUE";
>     SELECT ARRAY[1,2,3] *<> 4 AS "TRUE";

Couldn't this kind of operation be handled more cleanly (at least
semantically speaking), if we provide a function that converts an array to
a set and then use standard set searching operations?  For example,

SELECT 2 IN TABLE(ARRAY[1,2,3]);

> 5. Side note: I added ANYARRAY1 and ANYELEMENT1 in this version.

Doing what?

--
Peter Eisentraut   peter_e@gmx.net