Horton
Menu

Re: [SQL] indexing a datetime by date

Andrew Merrill <andrew@compclass.com>

View thread
From: Andrew Merrill <andrew@compclass.com>
To: "Jackson, DeJuan" <djackson@cpsgroup.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Thomas Lockhart <lockhart@alumni.caltech.edu>, pgsql-sql@hub.org, PGSQL Hackers <pgsql-hackers@hub.org>
Date: 1999-03-30T18:11:19Z
Lists: pgsql-hackers 
Jackson, DeJuan wrote:

> try:
>  explain select when from notes where datetime_date(when) = 'now'::date;
>         -DEJ

Aha.  That does the trick.  Thanks!

Andrew Merrill