Re: PostgreSQL Gotchas

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: PostgreSQL Gotchas
Дата
Msg-id 200510161937.56978.peter_e@gmx.net
обсуждение исходный текст
Ответ на Re: PostgreSQL Gotchas  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: PostgreSQL Gotchas  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane wrote:
> > 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.

This is used to create pretty column headers in table output.  We'd
surely get criticism if this no longer worked.

I guess you could get around that if you leave the case-folding in the
lexer as is but instead make the nameeq function case insensitive.
This is sort of the way the Windows file system works (I think).  (And
we know that *never* leads to problems... :-/)

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

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

Предыдущее
От: Matthew
Дата:
Сообщение: Re: PostgreSQL Gotchas
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Long running update