Re: Arrays of Complex Types

Gregory Stark <stark@enterprisedb.com> writes:
> "Tom Lane" <tgl@sss.pgh.pa.us> writes:
>> CREATE ARRAY TYPE FOR foo

> I also made a suggestion along the way that we never create array types
> automatically except for domains.

That seems awfully strange, not to mention very non-backwards-compatible
since it exactly reverses what happens now.

I'd be willing to consider it if a domain were a zero-cost addition to
the equation, but it is not --- every operation on a domain has to check
to see if there are constraints to enforce.  You shouldn't have to buy
into that overhead to have an array.
        regards, tom lane