Re: SQL99 ARRAY support proposal

Joe Conway <mail(at)joeconway(dot)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