On Mon, Oct 07, 2002 at 12:11:35PM -0400, Jean-Luc Lachance wrote:
> Shridhar Daithankar wrote:
> > Create an index on died field. And query like
> >
> > select * from pets where died < "last year july 4 7:01 PM;
> If the pet is still alive today died would be NULL and the where clause
> would not be true.
In that case check for NULL explicitly,
select * from pets where died > [date] or died is null;
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Porque francamente, si para saber manejarse a uno mismo hubiera que
rendir examen... ¿Quién es el machito que tendría carnet?" (Mafalda)
