Case insensitive hstore.

[Glenn Pierce <glennpierce@xxxxxxxxx>]

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