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


From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Michal Lijowski <michal(at)cvu(dot)wustl(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Using SELECT WHERE
Date: 2004-04-20 16:58:27
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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).

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2004-04-20 17:11:09
Subject: Re: Start with -i
Previous:From: Bruce MomjianDate: 2004-04-20 16:49:22
Subject: Re: question on forced-killing the postmaster

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