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