Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2]) by postgresql.org (Postfix) with ESMTP id DD2494769AA for ; Sun, 17 Mar 2002 19:56:06 -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 KAA25607 for ; Mon, 18 Mar 2002 10:57:45 +1000 X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5] claimed to be oasis.net.au Message-ID: <3C953AA0.30209@oasis.net.au> Date: Mon, 18 Mar 2002 10:53:52 +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: Re: Boolean test References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200203/222 X-Sequence-Number: 7101 Hi, Thanks for your replies. Peter was spot on. I was trying to use a reserved word 'public' 'public_plan' works fine. Kind regards Rudi Starcevic. Peter Eisentraut wrote: >Rudi Starcevic writes: > >>I can't see why my sql here is throwing an error, >> > >(Next time it might be nice to show *what* error...) > >> SELECT * >> FROM plan_template >> WHERE public = true; >> > >"public" is a reserved word. You need to double-quote it to be able to >use it. >