| From: | Michael Glaesemann <grzm(at)myrealbox(dot)com> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Accessing composite type columns in indexes |
| Date: | 2006-03-04 04:44:11 |
| Message-ID: | D4C62B26-11E1-4002-8A17-C13648E47144@myrealbox.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mar 4, 2006, at 13:34 , Michael Fuhr wrote:
> 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));
Thanks, Tom and Michael. I thought I had been aggressive enough in
applying parentheses.
On Mar 4, 2006, at 13:31 , Tom Lane wrote:
> Make sense now?
Yep!
Michael Glaesemann
grzm myrealbox com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Glaesemann | 2006-03-04 05:06:21 | Re: Accessing composite type columns in indexes |
| Previous Message | Michael Fuhr | 2006-03-04 04:34:04 | Re: Accessing composite type columns in indexes |