Re: [SQL] indexing a datetime by date

From: Andrew Merrill <andrew(at)compclass(dot)com>
To: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, pgsql-sql(at)hub(dot)org, PGSQL Hackers <pgsql-hackers(at)hub(dot)org>
Subject: Re: [SQL] indexing a datetime by date
Date: 1999-03-30 18:11:19
Message-ID: 370113C7.9555D2BC@compclass.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

Jackson, DeJuan wrote:

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

Aha. That does the trick. Thanks!

Andrew Merrill

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 1999-03-30 18:27:20 RE: [HACKERS] Should the following work...?
Previous Message Jackson, DeJuan 1999-03-30 17:42:21 RE: [HACKERS] Should the following work...?

Browse pgsql-sql by date

  From Date Subject
Next Message Clark Evans 1999-03-30 20:33:04 Selecting and deleting duplicate rows
Previous Message Andrew Merrill 1999-03-30 17:44:09 regexp strangeness