From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
Cc: | Postgresql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Better support for whole-row operations and composite |
Date: | 2004-03-30 19:09:21 |
Message-ID: | 11089.1080673761@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> Tom Lane wrote:
>> Only named composite types, not RECORD, will be allowed to be used as
>> table column types.
> Interesting. I'm slightly curious to know if there's an external driver
> for this.
There's noplace to store a permanent record of an anonymous rowtype's
structure. To do otherwise would amount to executing an implicit CREATE
TYPE AS for the user, so we might as well just say up front that you
have to create the type.
> Will this apply recursively (an a has a b which has an array of c's)?
Yup.
> Are there indexing implications? Could one index on a subfield?
Using an expression index, sure. I don't think we need to support it as
a "primitive" index type.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Conway | 2004-03-30 19:12:29 | cvs HEAD regression |
Previous Message | Tom Lane | 2004-03-30 19:04:15 | Re: with vs without oids in pg_catalog.* |