Re: Using SELECT WHERE

From: Christian Pöcher <Poecher(at)gmx(dot)net>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Using SELECT WHERE
Date: 2004-04-20 19:43:04
Message-ID: 001301c4270f$b5df4ec0$6009cad4@dose
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


----- Original Message -----
From: "Michal Lijowski" <michal(at)cvu(dot)wustl(dot)edu>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Thursday, April 15, 2004 9:03 PM
Subject: [NOVICE] Using SELECT WHERE

> RabStudies=> SELECT RabNo, ImplantDate, Comments FROM RabStudiesInfo
> where implantdate <> 0001-01-01;

You have to quote the date:
... where implantdate <> '0001-01-01';

chris

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Hari Bhanujan 2004-04-20 20:19:18 RE: [NOVICE] Création de BD
Previous Message Bruno Wolff III 2004-04-20 18:17:03 Re: question on forced-killing the postmaster