Re: Accessing composite type columns in indexes

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Michael Glaesemann <grzm(at)myrealbox(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Accessing composite type columns in indexes
Date: 2006-03-04 04:34:04
Message-ID: 20060304043404.GA55362@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Mar 04, 2006 at 12:21:38PM +0900, Michael Glaesemann wrote:
> create unique index employment_history_pkey_idx
> on employment_history (company, (during).from_date, (during).to_date);
> ERROR: syntax error at or near "." at character 89
> LINE 2: on employment_history (company, (during).from_date, (during)...
> ^

This works:

create unique index employment_history_pkey_idx
on employment_history (company, ((during).from_date), ((during).to_date));

--
Michael Fuhr

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2006-03-04 04:44:11 Re: Accessing composite type columns in indexes
Previous Message Tom Lane 2006-03-04 04:31:52 Re: Accessing composite type columns in indexes