Case insensitive primary keys

Поиск
Список
Период
Сортировка
От Jeff Schnitzer
Тема Case insensitive primary keys
Дата
Msg-id 7E95297C88EDED4EB43BADD11871FA798C12@CHILL.haunt.infohazard.org
обсуждение исходный текст
Список pgsql-general
Hello!  I've got a question:

I'm trying to create a system with a string (varchar) primary key which
is *not* case sensitive.  Is there any way I can create a primary key
column which automatically takes care of this?

I'm coming at this problem from a java app server, so my hands are
somewhat bound regarding the queries used to insert and search the
table.  There are solutions, but the ideal (for me) would be for the
database to ignore the case of my key column.  Is this possible?

Thanks,
Jeff

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: display temp table structure?
Следующее
От: "Thomas F. O'Connell"
Дата:
Сообщение: infinity