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

Re: Using SELECT WHERE

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: 20040420095740.P27700@megazone.bigpanda.com (view raw or flat)
Thread:
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-2014 The PostgreSQL Global Development Group