Using SELECT WHERE

Поиск
Список
Период
Сортировка
От Michal Lijowski
Тема Using SELECT WHERE
Дата
Msg-id 1082055782.11493.8.camel@ml-cvu.wustl.edu
обсуждение исходный текст
Ответы Re: Using SELECT WHERE  (Ron St-Pierre <rstpierre@syscor.com>)
Re: Using SELECT WHERE  (Bruno Wolff III <bruno@wolff.to>)
Re: Using SELECT WHERE  (Nabil Sayegh <postgresql@e-trolley.de>)
Re: Using SELECT WHERE  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Using SELECT WHERE  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: Using SELECT WHERE  (Christian Armeanu <chris@vote4ad.com>)
Список 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








В списке pgsql-novice по дате отправления:

Предыдущее
От: dayersystem@bluewin.ch (jedi)
Дата:
Сообщение: Création de BD
Следующее
От: "Colin Gillespie"
Дата:
Сообщение: Re: triggers