Re: Using SELECT WHERE - Mailing list pgsql-novice

From Stephan Szabo
Subject Re: Using SELECT WHERE
Date
Msg-id 20040420095740.P27700@megazone.bigpanda.com
Whole thread Raw
In response to Using SELECT WHERE  (Michal Lijowski <michal@cvu.wustl.edu>)
List pgsql-novice
On Thu, 15 Apr 2004, 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;

You forgot to quote the date, what you're getting is
Date <> Integer (1-1-1).


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Start with -i
Next
From: Bruce Momjian
Date:
Subject: Re: question on forced-killing the postmaster