Received: from sss.pgh.pa.us ([192.204.191.242])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id g1F0lAE13483
	for <pgsql-sql@postgresql.org>; Thu, 14 Feb 2002 19:47:10 -0500 (EST)
	(envelope-from tgl@sss.pgh.pa.us)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g1F0kcf10783;
	Thu, 14 Feb 2002 19:46:38 -0500 (EST)
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
cc: Josh Berkus <josh@agliodbs.com>, Matthew Price <pricem@juno.com>,
	pgsql-sql@postgresql.org
Subject: Re: Index not being used 
In-reply-to: <20020214150423.R24897-100000@megazone23.bigpanda.com> 
References: <20020214150423.R24897-100000@megazone23.bigpanda.com>
Comments: In-reply-to Stephan Szabo <sszabo@megazone23.bigpanda.com>
	message dated "Thu, 14 Feb 2002 15:08:45 -0800"
Date: Thu, 14 Feb 2002 19:46:38 -0500
Message-ID: <10780.1013733998@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Archive-Number: 200202/167
X-Sequence-Number: 6593

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 write
	WHERE cdate = date 'now'
instead.

			regards, tom lane