Re: Boolean test

Поиск
Список
Период
Сортировка
От Rudi Starcevic
Тема Re: Boolean test
Дата
Msg-id 3C953AA0.30209@oasis.net.au
обсуждение исходный текст
Ответ на Re: Boolean test  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: Dima Tkach
Дата:
Сообщение: Re: Btree index extension question
Следующее
От: "Dorian Taylor"
Дата:
Сообщение: Creative use of CASE in a GROUP BY clause