Re: INDEX on a composite type

From: GMail <vincenzo(dot)romano(at)gmail(dot)com>
To: Colin Wetherbee <cww(at)denterprises(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: INDEX on a composite type
Date: 2007-12-19 21:41:36
Message-ID: 200712192241.36337.vincenzo.romano@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Il Wednesday 19 December 2007 22:29:25 Colin Wetherbee ha scritto:
> GMail wrote:
> > When trying to create an index on a composite type, I need to enclose
> > the columns in paranthesis. Is this normal?
> > I don't think so as there's no mention in the friendly manual.
>
> I think your problem is similar to one that has been discussed here
> previously.
>
> http://www.mail-archive.com/pgsql-general(at)postgresql(dot)org/msg75862.html
>
> Colin

By the way, why not allowing the declaration of an index over a composite
type as a whole? (As opposed to a composite type as the list of single
component types).

--
Vincenzo Romano
Maybe Computers will never become as intelligent as Humans.
Surely they won't ever become so stupid. [VR-1989]

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike C 2007-12-19 22:14:33 Postgres 8.3 HOT and non-persistent xids
Previous Message Geoff Ellingwood 2007-12-19 21:41:15 Re: Trouble running PostgreSQL server / Server must be started under certain locale.