Re: hstore, but with fast range comparisons?

Andy Colson wrote
> On 11/13/2014 3:46 PM, Guyren Howe wrote:
>> I want to do something that is perfectly satisfied by an hstore column.
>> *Except* that I want to be able to do fast (ie indexed) <, > etc
>> comparisons, not just equality.
>>
>> From what I can tell, there isn’t really any way to get hstore to do
>> this, so I’ll have to go to a key-value table. But I thought I’d ask just
>> in case I’m missing something.
>>
>
> I think your missing something.
>
> Is it one field in the hstore? Did you try an expression index?
>
> create index cars_mph on cars ( (data->'mph') );
>
> thats a btree index, which should support < and >. (Although I've never
> tried it)

With the one caveat that everything in hstore is a string so you'd probably
want to add an appropriate cast to the expression.

David J.

--
View this message in context: http://postgresql.nabble.com/hstore-but-with-fast-range-comparisons-tp5826886p5826898.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.