Received: from fullfeed.msn.fullfeed.com (fullfeed.msn.fullfeed.com [199.184.182.42]) by hub.org (8.9.2/8.9.1) with SMTP id NAA74620; Tue, 30 Mar 1999 13:13:16 -0500 (EST) (envelope-from <@snapuser35.pacificcrest.net:andrew@compclass.com>) Received: from thatch2.compclass.com by fullfeed.msn.fullfeed.com (8.6.9/MSN-1.4) id MAA17522; Tue, 30 Mar 1999 12:12:57 -0600 Received: from snapuser35.pacificcrest.net by thatch2.compclass.com id aa10988; 30 Mar 99 12:15 CST Sender: andrew@compclass.com Message-ID: <370113C7.9555D2BC@compclass.com> Date: Tue, 30 Mar 1999 10:11:19 -0800 From: Andrew Merrill X-Mailer: Mozilla 4.04 [en] (X11; I; UnixWare 5 i386) MIME-Version: 1.0 To: "Jackson, DeJuan" CC: Tom Lane , Thomas Lockhart , pgsql-sql@hub.org, PGSQL Hackers Subject: Re: [SQL] indexing a datetime by date References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Jackson, DeJuan wrote: > try: > explain select when from notes where datetime_date(when) = 'now'::date; > -DEJ Aha. That does the trick. Thanks! Andrew Merrill