Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] indexing a datetime by date - Mailing list pgsql-hackers

From Andrew Merrill
Subject Re: [SQL] indexing a datetime by date
Date
Msg-id 370113C7.9555D2BC@compclass.com
Whole thread Raw
In response to RE: [SQL] indexing a datetime by date  ("Jackson, DeJuan" <djackson@cpsgroup.com>)
List pgsql-hackers
Tree view 
Jackson, DeJuan wrote:

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

Aha.  That does the trick.  Thanks!

Andrew Merrill

pgsql-hackers by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [HACKERS] Should the following work...?
Next
From: The Hermit Hacker
Date:
Subject: RE: [HACKERS] Should the following work...?