Re: Query about Boolean Data Type - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Query about Boolean Data Type
Date
Msg-id 20030809152137.GC22927@wolff.to
Whole thread Raw
In response to Query about Boolean Data Type  ("Richard Hurst" <richard.hurst@kirklees.gov.uk>)
List pgsql-novice
On Fri, Aug 08, 2003 at 10:29:37 +0100,
  Richard Hurst <richard.hurst@kirklees.gov.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;

pgsql-novice by date:

Previous
From: "John T. Yocum"
Date:
Subject: CURRENT TIME causes server to shutdown connection
Next
From: Tom Lane
Date:
Subject: Re: CURRENT TIME causes server to shutdown connection