Re: Better support for whole-row operations and composite

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Postgresql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Better support for whole-row operations and composite
Date: 2004-03-30 15:19:21
Message-ID: 40698FF9.3090503@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2004-03-30 15:46:28 Re: GIST code doesn't build on strict 64-bit machines
Previous Message Tom Lane 2004-03-30 14:26:13 Re: pg_dump end comment