Re: PostgreSQL Gotchas

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: PostgreSQL Gotchas
Дата
Msg-id 4353B01A.5050201@Yahoo.com
обсуждение исходный текст
Ответ на Re: PostgreSQL Gotchas  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: PostgreSQL Gotchas  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On 10/16/2005 12:40 PM, Tom Lane wrote:
> Martijn van Oosterhout <kleptog@svana.org> writes:
>> Actually, perhaps an even more restricted version would be better.
>> Lowercase quoted identifiers only if they are all uppercase. So then:
>
> No, I think the original proposal was better.  This one doesn't fix
> things for the lusers who think "MixedCase" and unquoted MixedCase
> should be the same.

What is bad about leaving pg_catalog all lower case and expect everyone
to query the catalog quoted? We would be totally free as to the
flexibility of the new option. One setting could even act 100% according
to the standard ... a feature I'm missing so far in all the proposals.


Jan

>
>> Note to implementor: In 'SELECT 1 as "Title"', the quoted string should
>> not be lowercased, even if you are lowercasing everything else...
>
> You don't get to have that, I think, because the lexer is not context
> aware.  It's not clear to me why it's a good idea anyway.
>
>             regards, tom lane


--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #

В списке pgsql-general по дате отправления:

Предыдущее
От: "Cristian Prieto"
Дата:
Сообщение: Re: dynamic loading of .so
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL Gotchas