Re: Arrays of Complex Types - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Arrays of Complex Types
Date
Msg-id 5667.1175109866@sss.pgh.pa.us
Whole thread Raw
In response to Re: Arrays of Complex Types  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Arrays of Complex Types  (David Fetter <david@fetter.org>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Arrays of Complex Types
Next
From: Bruce Momjian
Date:
Subject: Re: Patch queue concern