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