| 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
> > )
| 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 |