Boolean test

From: Rudi Starcevic <rudi(at)oasis(dot)net(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: Boolean test
Date: 2002-03-15 04:32:57
Message-ID: 3C917979.5020806@oasis.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-03-15 04:58:02 Re: Boolean test
Previous Message Tom Lane 2002-03-15 00:03:45 Re: [SQL] Syslog