hstore, but with fast range comparisons?

From: Guyren Howe <guyren(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: hstore, but with fast range comparisons?
Date: 2014-11-13 21:46:17
Message-ID: 9519F7D6-B395-4834-8EA2-E6095A6F4ED7@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Vanasco 2014-11-13 22:17:26 Re: Are there any downsides to using postgres' data directory on a dedicated drive/partition / filesystem?
Previous Message Tom Lane 2014-11-13 21:44:23 Re: Are there any downsides to using postgres' data directory on a dedicated drive/partition / filesystem?