Case insensitive hstore. - Mailing list 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