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).
In response to
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2004-04-20 17:11:09|
|Subject: Re: Start with -i |
|Previous:||From: Bruce Momjian||Date: 2004-04-20 16:49:22|
|Subject: Re: question on forced-killing the postmaster|