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