Re: Efficient date range search?

On 4 Oct 2002 at 23:35, mvh@ix.netcom.com wrote:

> CREATE TABLE "pets" (
>     name VARCHAR(20);
>     "born" timestamp;
>     "died" timestamp;
> );
>
> and I have a LOT of pets (let's say millions) and some don't live too
> long (mice, fruitflies, whatever), and some do (parrots, elephants).
>
> I would like to make a query to say
>
> on july 4 of last year, what pets were alive?
>
> and I would like to make this query right to the minute
>
> on july 4 of last year at 7:01 PM what pets were alive?

Create an index on died field. And query like

select * from pets where died < "last year july 4 7:01 PM;

These will be alive pets then.. Should be pretty efficient.

Bye
 Shridhar

--
QOTD:    Money isn't everything, but at least it keeps the kids in touch.