Re: Accessing composite type columns in indexes

[Michael Fuhr <mike@xxxxxxxx>]

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