Re: Accessing composite type columns in indexes - Mailing list 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