Case sensitive field names

Поиск
Список
Период
Сортировка
От Jarmo Paavilainen
Тема Case sensitive field names
Дата
Msg-id 000a01c0278c$f967ad80$1501a8c0@theboss.comder.private
обсуждение исходный текст
Список pgsql-hackers
Hi,

Is there a way to make postgre insensitive about field name cases?

Like "initdb --fields-are-case-insensitive --compares-are-case-insensitive"

Yes I know about "CaseIsKept" and CaseIsNotKept (note the quotes). But that
gives me more trouble than it solves. And what about "case insensitive field
name with spaces". I believe that space is legal in field names.

Are there any real reason why postgre is sensitive about field names (except
SQL92 states that this is how it must be)?

I suppose somewhere along the way I have all field names separated from the
query, and in which file(s) does that happen? (So I can do my own hack, add
"tolower(fieldName)").

Ive tried to locate the right files in the source for 7.0.2, but there are
more that one file.

// Jarmo



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

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: byacc problem with FreeBSD ...
Следующее
От: devik@cdi.cz
Дата:
Сообщение: pgsql is 75 times faster with my new index scan