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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
