Re: Efficient date range search?

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Efficient date range search?
Date: 2002-10-08 17:21:19
Message-ID: Pine.LNX.4.21.0210081817160.3248-100000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Actually it is supposed to give correct results

As a bonus it follows standard DB practices rather than falling into the 9/9/99
trap which everyone was so worried about a couple of years ago.

On Mon, 7 Oct 2002, Jean-Luc Lachance wrote:

> And that is supposed to be more efficient then
> select * from pets where died > {whatever date};
>
> C'mon...
>
>
> "Nigel J. Andrews" wrote:
> >
> > SELECT *
> > FROM pets
> > WHERE
> > born <= '2001-07-04 07:01:00+00'
> > AND
> > (
> > died > '2001-07-04 07:01:00+00'
> > OR
> > died is NULL
> > )

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2002-10-08 17:42:20 Re: CHAR, VARCHAR, TEXT (Was Large Databases)
Previous Message Johnson, Shaunn 2002-10-08 16:21:05 phpPgAdmin + PostgreSQL + authentication