Using SELECT WHERE
От | Michal Lijowski |
---|---|
Тема | Using SELECT WHERE |
Дата | |
Msg-id | 1082055782.11493.8.camel@ml-cvu.wustl.edu обсуждение исходный текст |
Ответы |
Re: Using SELECT WHERE
Re: Using SELECT WHERE Re: Using SELECT WHERE Re: Using SELECT WHERE Re: Using SELECT WHERE Re: Using SELECT WHERE |
Список | 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 по дате отправления: