Stephan Szabo <sszabo@megazone23.bigpanda.com> writes:
> Something tells me that current_date is probably not in a form that's
> considered indexable.
More to the point, it's not considered a constant.
You could writeWHERE cdate = date 'now'
instead.
regards, tom lane