Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group