On Wed, 20 Feb 2002 13:49:21 -0500
"Rod Taylor" <rbt@zort.ca> wrote:
> Couldn't you simply index on the cast of the timestamp to date?
>
> create index ix_test on testtable (cast(things as date));
> ERROR: parser: parse error at or near "cast"
>
> Evidently not...
I'm sorry.
>> I would think that you're able to create an index easily like (2), but need to >> inspect the results cautiously.
This means "create an index on an function", not "create an index on adate()/cast() directly". It seemed ambiguous.
Regards,
Masaru Sugawara