Re: Index not being used

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.