Re: Indexes of dates?

Paul J. Lucas wrote:

>     From the documentation, there doesn't seem to be any way to
>     either create indexes using a "date" type or perform queries
>     using dates, e.g., find all those documents such that the
>     origDate element is later than X and earlier than Y.
>
>     So, can Xindice deal with dates?
>
>     - Paul

This is a limitation of XPATH. There is no facility
for date comparison (will be in a future version).

I got around this by specifying date/time in
"milliseconds since epoch" form. Numeric
values can be indexed and compared using
Xindice.

One can then apply a numeric (e.g. integer) index
to this element or attribute.

However, numeric indices for multi-byte values
are broken in xindice. I use a modified version
of xindice that I've patched to work correctly
for 0 and positive values (fixing the problem for
negative values is much more involved).

See bug 19203 - "ValueIndexer for Multi-Byte Numeric Types Broken"
<http://issues.apache.org/bugzilla/show_bug.cgi?id=19203>for details of 
the bug and the workaround I use.

-Terry