Re: Query about Boolean Data Type

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Richard Hurst <richard(dot)hurst(at)kirklees(dot)gov(dot)uk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Query about Boolean Data Type
Date: 2003-08-09 15:21:37
Message-ID: 20030809152137.GC22927@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, Aug 08, 2003 at 10:29:37 +0100,
Richard Hurst <richard(dot)hurst(at)kirklees(dot)gov(dot)uk> wrote:
> Hi
>
> This may seem a bit simplistic but how do you match a select on a
> boolean data column where the entry is false or null

select * from table where columun is false or column is null;
or
select * from table where not column is true;

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2003-08-09 15:35:51 Re: Upgrade 7.2 to 7.3
Previous Message Tom Lane 2003-08-09 15:10:40 Re: CURRENT TIME causes server to shutdown connection