Re: Accessing composite type columns in indexes

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>, Michael Fuhr <mike(at)fuhr(dot)org>
Subject: Re: Accessing composite type columns in indexes
Date: 2006-03-04 05:45:18
Message-ID: 4B7E5F2A-C677-4E53-973A-537A9D7B5176@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mar 4, 2006, at 14:17 , Tom Lane wrote:

> The UNIQUE/PRIMARY KEY syntax only allows bare column names, per
> the SQL
> standard. While there's not any technical reason why we couldn't
> extend
> that syntax, there's a pretty large fear factor involved: we could
> find
> ourselves behind the spec-compliance eight-ball if the SQL committee
> exercises their prerogative to extend the syntax in some other
> direction.

Cool. Thanks for the explanation.

Michael Glaesemann
grzm myrealbox com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Istvan Nagy 2006-03-04 06:17:12 Re: problem with windows xp sp2 and postgres-8.1.3
Previous Message Tom Lane 2006-03-04 05:17:39 Re: Accessing composite type columns in indexes