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,

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

Reply via email to