Ernst Molitor (molitor(at)uni-bonn(dot)de) reports a bug with a severity of 3
The lower the number the more severe it is.
create index ... (date_part('year', d)) fails
IMHO, creation of an index on a part of a date field should work,
but it fails due to the definition of "create index ..." in gram.y.
Maybe I'm wrong, but I feel that for large tables which will have to be analyzed per year, an index of this kind could be an advantage.
-- the table
create table test (d date);
-- partial indices:
create index d_year on test (date_part('year', d));
-- fails with: ERROR: parser: parse error at or near "'"
create index d_year on test (extract(year from d));
-- fails with: ERROR: parser: parse error at or near "("
No file was uploaded with this report
pgsql-bugs by date
|Next:||From: Viacheslav N Tararin||Date: 2002-03-15 14:09:26|
|Previous:||From: 'Ben Grimm'||Date: 2002-03-15 13:23:58|
|Subject: Re: Bug #613: Sequence values fall back to previously chec|