Re: Better support for whole-row operations and composite - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Better support for whole-row operations and composite
Date
Msg-id 40698FF9.3090503@dunslane.net
Whole thread Raw
In response to Better support for whole-row operations and composite types  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Better support for whole-row operations and composite  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

>We have a number of issues revolving around the fact that composite types
>(row types) aren't first-class objects.  I think it's past time to fix
>that.  Here are some notes about doing it.  I am not sure all these ideas
>are fully-baked ... comments appreciated.
>
>  
>
[snip]

>Only named composite types, not RECORD, will be allowed to be used as
>table column types.  
>
[snip]

Interesting. I'm slightly curious to know if there's an external driver 
for this.

Will this apply recursively (an a has a b which has an array of c's)? 
Are there indexing implications? Could one index on a subfield?

cheers

andrew


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_dump end comment
Next
From: Bruce Momjian
Date:
Subject: Re: feature request: \qf datatype