Re: Using SELECT WHERE

Michal Lijowski wrote:

>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;
>
>
Try quoting the date:

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
>
>
Ron