SV: Case sensitive field names - Mailing list pgsql-hackers

From Jarmo Paavilainen
Subject SV: Case sensitive field names
Date
Msg-id 000f01c027de$3f949920$1501a8c0@theboss.comder.private
Whole thread Raw
In response to Re: Case sensitive field names  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
...
> > Is there a way to make postgre insensitive about field name cases?
> >
> > Like
"initdb --fields-are-case-insensitive --compares-are-case-insensitive"
...
> The main problem I see with case-insensitivity is the fact that there
> are always more than one way to do it, as it depends on charset _and_
locale ;(
>
> For example 'Ä'=='ä' in my locale but not in US, not to mention that in
> some locales even the character count may change when going from upper to
> lower case.

Thats not really a problem with field names. *I think* you should always use
ASCII chars in fieldnames (and only those between 32 (space) and 'z'.

And PostgreSQL should cope with case insensitive search. If not, then I can
not use it.

Can PostgreSQL do a case insensitive search?

...
> arbitraryly-case-altering OS-es, like the ones Microsoft produces.

Yeah and microsoft SQL server can do a case insensitive search, so can
Sybase (at least the Win versions).

...
> > query, and in which file(s) does that happen? (So I can do my own hack,
add
> > "tolower(fieldName)").
...
> I guess the best place would be sobewhere very near lexer.

Ill look for a good spot.

> You could also try just uppercasing anything outside ''/"" even before
> it is passed to backend.

No good, because field values should keep case (even if you search on them
case insensitive). But then again to use " as a field value delimiter is
illegal, isnt it?

// Jarmo



pgsql-hackers by date:

Previous
From: "G. Anthony Reina"
Date:
Subject: PostgreSQL 7.0.3?
Next
From: The Hermit Hacker
Date:
Subject: Re: PostgreSQL 7.0.3?