On Tue, Sep 2, 2014 at 9:55 PM, Peter Geoghegan <peter.geoghega...@gmail.com > wrote:
> On Tue, Sep 2, 2014 at 9:38 PM, Joe Van Dyk <j...@tanga.com> wrote: > > I want to return all rows that have a value of less than 10. I have > > arbitrary keys I want to check (not just 'a'). > > > If you created an expression B-Tree index on 'a' it would work for > 'a', but you'd have to use a jsonb literal, not a json/int4 literal. > If you want to be able to query every key at the top nesting level of > an object, such that all rows are returned with jsonbs that have > object values of which in each case one of them is, say, below 10, > Just a particular key specified in the query, not just any of them. I may want key 'a' one time, and 'b' the next time. Not sure if that's what you meant. I figured since I could do equality, I should be able to do less than and greater than. Joe > then that's something that no existing opclass can support. But, why > should it be supported? That's a very fuzzy criteria to search on. > > -- > Regards, > Peter Geoghegan >