Re: jsonb and comparison operators
От | Oleg Bartunov |
---|---|
Тема | Re: jsonb and comparison operators |
Дата | |
Msg-id | CAF4Au4wnOYpMtro0ZM3=h5rpZ3w=XGx_-Q2fsCz97-+iO8_YNA@mail.gmail.com обсуждение исходный текст |
Ответ на | jsonb and comparison operators (Joe Van Dyk <joe@tanga.com>) |
Список | pgsql-general |
jsquery (https://github.com/akorotkov/jsquery) should works for you.
On Wed, Sep 3, 2014 at 8:38 AM, Joe Van Dyk <joe@tanga.com> wrote:
Is it possible to get this query (or a similar one) to use an index?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').drop table if exists test;create table test (j jsonb);insert into test select json_build_object('a', i)::jsonb from generate_series(1, 100000) i;create index on test using gin(j);vacuum analyze test;select * from test where (j->>'a')::int < 10;I triedselect * from test where j->'a' < 10::json::jsonb;but didn't seem to use the index.
В списке pgsql-general по дате отправления: