On Thu, 14 Feb 2002, Josh Berkus wrote:
> Matthew,
>
> 1. Is field cdate DATE or TIMESTAMP?
> 2. What happens with:
> EXPLAIN SELECT cdate FROM sometable WHERE cdate = '2001-02-14'::DATE or
> TIMESTAMP?
> 3. Please time both queries and give the number of resulting rows from
> both queries.
Something tells me that current_date is probably not in a form that's
considered indexable. You could probably get around that with an
iscachable function hiding it however.