Postgres Pro
Downloads
Home   >   mailing lists

Re: Boolean test - Mailing list pgsql-sql

From Rudi Starcevic
Subject Re: Boolean test
Date
Msg-id 3C953AA0.30209@oasis.net.au
Whole thread Raw
In response to Re: Boolean test  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
Tree view 
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.
>

pgsql-sql by date:

Previous
From: Dima Tkach
Date:
Subject: Re: Btree index extension question
Next
From: "Dorian Taylor"
Date:
Subject: Creative use of CASE in a GROUP BY clause