Received: from wm8.jersey.juno.com (wm8.jersey.juno.com [64.136.16.228]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1EM4eE92365 for ; Thu, 14 Feb 2002 17:04:40 -0500 (EST) (envelope-from pricem@juno.com) Received: from cookie.juno.com by cookie.juno.com for <"/TkDBi7JJ2b6tmw2z88AACrveW/TOkXi72wVld0R/zitkySJ98ri7w=="> Received: (from pricem@juno.com) by wm8.jersey.juno.com (jqueuemail) id GTMZU9LH; Thu, 14 Feb 2002 17:04:39 EST X-Original-From: "Matthew Price" Date: Thu, 14 Feb 2002 22:04:24 GMT To: pgsql-sql@postgresql.org Subject: Re: Index not being used X-Mailer: Juno Webmail Version 1.0 From: Matthew Price Message-Id: <20020214.170439.16294.16467@wm8.jersey.juno.com> X-Archive-Number: 200202/164 X-Sequence-Number: 6590 >Please post your PostgreSQL version, and the actual explain output of >both queries. EXPLAIN SELECT cdate FROM sometable WHERE cdate = current_date; NOTICE: QUERY PLAN: Seq Scan on sometable (cost=0.00..332.70 rows=71 width=186) EXPLAIN SELECT cdate FROM sometable WHERE cdate = '02/14/2002'; NOTICE: QUERY PLAN: Index Scan using sometable_cdate on sometable (cost=0.00..66.64 rows=71 width=186) My postgres version is 7.1.3 Again, thanks for any help Matthew Price ________________________________________________________________ GET INTERNET ACCESS FROM JUNO! Juno offers FREE or PREMIUM Internet access for less! Join Juno today! For your FREE software, visit: http://dl.www.juno.com/get/web/.