Hello, after reading the thread on "Typed hstore proposal", I wonder if another minded extension of hstore would be benefical: add additional hstore types with numerical data type for the values.
e.g.: hstore_float : text -> float This should allow to add some nice aggregation function on these hstore, e.g. select distinct_sum(x) from ( a -> 1 b -> 5 a -> 3 c -> 2 ) => a -> 4 b -> 5 c -> 2 I have a small case where I'm doing this with a custom type (text, float) , but with poor performances. I guess that such an extension would make sense if it were to bring a significant performance gain compared to the custom type approach. best regards and Merry Christmas, Marc Mamin