Case insensitive hstore.

Поиск
Список
Период
Сортировка
От Glenn Pierce
Тема Case insensitive hstore.
Дата
Msg-id CAM5ipV8rU0OXaDtuJyyr+U6JmKaeXrjgaDn0F=hsupax18eY0Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Case insensitive hstore.  (Ian Lawrence Barwick <barwick@gmail.com>)
Список pgsql-general
Hi

Does anyone know how one would
select from a table with a hstore field treating the key of the hstore as
case insensitive.

ie

SELECT id, lower(additional_info->'type') AS type FROM table

I would like this to work even if if the store tyoe is

'Type' -> 'original'


failing that is there a way to lowercase the keys and values of the hstore
field of the entire table ?

Thanks

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Avoiding duplication of code via views -- slower? How do people typically do this?
Следующее
От: "Gauthier, Dave"
Дата:
Сообщение: Re: How to get stored procedure args list from metadata tables ?