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