Re: INDEX on a composite type - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: INDEX on a composite type
Date
Msg-id 20071219212725.GB24426@svana.org
Whole thread Raw
In response to INDEX on a composite type  (GMail <vincenzo.romano@gmail.com>)
List pgsql-general
On Wed, Dec 19, 2007 at 10:07:32PM +0100, GMail wrote:
> Hi all.
>
> 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 beleive it says somewhere that anything except straight column names
need parenthesis. What you have is an expression and thus it needs
them.

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

Attachment

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: Partitioned tables & Slony
Next
From: Colin Wetherbee
Date:
Subject: Re: INDEX on a composite type