Case insensitive query on existing data

Поиск
Список
Период
Сортировка
От Saurav Sarkar
Тема Case insensitive query on existing data
Дата
Msg-id CAP+kwAUaeWHSvHVfqsJQ7cRMaBYZ36_khiwdiV3wZ3O1qabr7Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Case insensitive query on existing data  (Michael Lewis <mlewis@entrata.com>)
Список pgsql-general
Hi All,

We use PostgreSQL JSONB storage.

One of the keys in the JSON will be always have a "name" key.

We want to perform case insensitive query on the name key.

Our application is already live so we have some data and have existing indexes on the name key.

I understand that one of the ways is to create index on the lower(name)  and use the lower function. And then to recreate the indexes on the name key.

Is there any other way through which this can be achieved ? May be an option to not to recreate indexes.

Thanks and Best Regards,
Saurav

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

Предыдущее
От: mohand oubelkacem makhoukhene
Дата:
Сообщение: Implement a new data type
Следующее
От: Naveen Kumar
Дата:
Сообщение: Bytea Example