Re: INDEX on a composite type

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: GMail <vincenzo(dot)romano(at)gmail(dot)com>
Cc: Colin Wetherbee <cww(at)denterprises(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: INDEX on a composite type
Date: 2007-12-20 10:38:42
Message-ID: 20071220103842.GC16113@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 19, 2007 at 10:41:36PM +0100, GMail wrote:
> 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).

It would probably work if there was an operator class defined for your
type, but there's no magic for that.

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-12-20 10:51:34 Re: Quick Regex Question
Previous Message Howard Cole 2007-12-20 10:36:08 Re: Quick Regex Question