Joe Conway <mail@joeconway.com> writes:
> select ARRAY[1,2,3];
> result '{1,2,3}'
The array type is determined how? I'd like this syntax better if there
were a way to force the choice of array type...
> select ARRAY[(select oid from pg_class order by relname)];
> result is array of all the oid's in pg_class in relname order
Puh-leez tell me that's not in the spec. How is one supposed to
distinguish this usage from the scalar-subselect case?
> select ARRAY[1,2] || 3
> result '{1,2,3}'
Datatypes? How many variants of the || operator do you plan to offer?
What will be the side-effects on the parser's ability to pick one?
> select ARRAY[1,2] || ARRAY[3,4]
> result '{1,2,3,4}'
Same worry as above; likewise for the "proposed extensions".
regards, tom lane