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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
