Using SELECT WHERE

From: Michal Lijowski <michal(at)cvu(dot)wustl(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: Using SELECT WHERE
Date: 2004-04-15 19:03:03
Message-ID: 1082055782.11493.8.camel@ml-cvu.wustl.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I made a database and I would like to select entries
which have data not equal to the specified date.
I have postgresql-7.3.4-11 on Red Hat Fedora Core 1.

Here is the command

RabStudies=> SELECT RabNo, ImplantDate, Comments FROM RabStudiesInfo
where implantdate <> 0001-01-01;

and I get

rabno | implantdate | comments

307 | 2004-02-23 | No mimetic No target
309 | 2004-02-23 | No mimetic No target; Frame 12 study terminated
314 | 2004-02-27 | No mimetic No target
311 | 2004-02-27 | No mimetic No target
310 | 2004-02-26 | No mimetic No target No decoy
315 | 0001-01-01 | No Tumor
320 | 0001-01-01 | No Tumor
316 | 0001-01-01 | No Tumor
313 | 0001-01-01 | No Tumor

Why entries with implandate are listed?
It is the same when I use != instead of <>.

Thanks,

Michal

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Stijn Vanroye 2004-04-16 08:33:01 Installing 7.4.2 - ./configure error
Previous Message Iandé Coutinho 2004-04-15 18:49:57 triggers