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,
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2011-12-23 13:23:09|
|Subject: Re: Moving more work outside WALInsertLock|
|Previous:||From: Magnus Hagander||Date: 2011-12-23 11:54:22|
|Subject: Re: xlog location arithmetic|