Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2]) by postgresql.org (Postfix) with ESMTP id 21378475484 for ; Thu, 14 Mar 2002 23:35:20 -0500 (EST) Received: from oasis.net.au (guardian [210.8.139.5]) by water.oasis.net.au (8.9.3/100.1) with ESMTP id OAA23019 for ; Fri, 15 Mar 2002 14:36:29 +1000 X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5] claimed to be oasis.net.au Message-ID: <3C917979.5020806@oasis.net.au> Date: Fri, 15 Mar 2002 14:32:57 +1000 From: Rudi Starcevic User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:0.9.8) Gecko/20020204 X-Accept-Language: en-us MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Boolean test Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200203/194 X-Sequence-Number: 7074 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.