Boolean test - Mailing list pgsql-sql

From Rudi Starcevic
Subject Boolean test
Date
Msg-id 3C917979.5020806@oasis.net.au
Whole thread Raw
Responses Re: Boolean test  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Re: Boolean test  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
Hi,

I can't see why my sql here is throwing an error,   SELECT    *   FROM    plan_template   WHERE    public = true;

The field public is 'boolean'

I've also tried :   WHERE    public = 'true';   WHERE    public = t;   WHERE    public = 't';   WHERE    public =
'Yes';

Can you offer some advice ?
Thanks
Rudi.



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [ADMIN] Syslog
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Boolean test