Re: case sensitive identifiers in 7.3.4

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: case sensitive identifiers in 7.3.4
Дата
Msg-id 200407080732.21671.peter_e@gmx.net
обсуждение исходный текст
Ответ на case sensitive identifiers in 7.3.4  (Dana Hudes <dhudes@tcp-ip.info>)
Список pgsql-bugs
Dana Hudes wrote:
> The documentation clearly states in section "1.1.1 Identifiers and
> Keywords" that "Identifier and key word names are case insensitive".
> It goes on to give an example where a column name is used in lower
> case and in upper case or any mixture.
>
> I have found that the actual implemented behavior is not
> in conformance with the above. It can be demonstrated in psql
> if you create a column whose name is mixed case , e.g. "DocRoot" in
> table "websites" that
>     select "DocRoot" from "websites";
> works and that
>     select "docroot" from "websites" does not.

Reread the above section up to the very end and then come back.

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

Предыдущее
От: Dana Hudes
Дата:
Сообщение: case sensitive identifiers in 7.3.4
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Can't join on null values