Re: jsonb and nested hstore
От | Alexander Korotkov |
---|---|
Тема | Re: jsonb and nested hstore |
Дата | |
Msg-id | CAPpHfdsUHg-fRNi3Zu+m8rQuhNW2t_xo-PoWBr2Nh_L9Mwr0cQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: jsonb and nested hstore (Peter Geoghegan <pg@heroku.com>) |
Ответы |
Re: jsonb and nested hstore
|
Список | pgsql-hackers |
On Mon, Mar 10, 2014 at 1:18 PM, Peter Geoghegan <pg@heroku.com> wrote:
------
With best regards,
Alexander Korotkov.
* The jsonb_hash_ops non-default GIN opclass is broken. It has its ownidiosyncratic notion of what constitutes containment, that sees it
only return, say, jsonb arrays that have a matching string as their
"leftmost" element (if we ask it if it contains within it another
array with the same string). Because of the limited number of
indexable operators (only @>), I'd put this opclass in the same
category as GiST in terms of my willingness to forgo it for a release,
even if it did receive a loud applause at pgConf.EU. Again, it might
be some disparity between the opertors as they existed in hstore2 at
one time, and as they exist in the core code now, but I doubt it, not
least since the regression tests didn't pick this up, and it's such a
basic thing. Perhaps Oleg and Teodor just need to explain this to me.
I din't get comment about "leftmost" element. There is absolutely no distinguish between array elements. All elements are extracted into same keys independent of their indexes. It seems to have no change since I wrote hstore_hash_ops. Could you share test case to illustrate what you mean?
With best regards,
Alexander Korotkov.
В списке pgsql-hackers по дате отправления: