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