Re: jsonb and nested hstore

Поиск
Список
Период
Сортировка
Искать
От
Christophe Pettus
Тема
Re: jsonb and nested hstore
Дата
Msg-id
81A5AEBB-7E74-463F-8E06-0275F2188228@thebuild.com
Ответ на
Re: jsonb and nested hstore (Peter Geoghegan)
Список
Дерево обсуждения
jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Alvaro Herrera <alvherre@2ndquadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Alvaro Herrera <alvherre@2ndquadrant.com>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Teodor Sigaev <teodor@sigaev.ru>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore "Erik Rijkers" <er@xs4all.nl>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Hannu Krosing <hannu@2ndQuadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Hannu Krosing <hannu@2ndQuadrant.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Alvaro Herrera <alvherre@2ndquadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Thom Brown <thom@linux.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Thom Brown <thom@linux.com>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Oleg Bartunov <obartunov@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Oleg Bartunov <obartunov@gmail.com>
Re: jsonb and nested hstore Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Oleg Bartunov <obartunov@gmail.com>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Teodor Sigaev <teodor@sigaev.ru>
Re: jsonb and nested hstore Teodor Sigaev <teodor@sigaev.ru>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Oleg Bartunov <obartunov@gmail.com>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Teodor Sigaev <teodor@sigaev.ru>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Teodor Sigaev <teodor@sigaev.ru>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Teodor Sigaev <teodor@sigaev.ru>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Teodor Sigaev <teodor@sigaev.ru>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore "Erik Rijkers" <er@xs4all.nl>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Alvaro Herrera <alvherre@2ndquadrant.com>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Tomas Vondra <tv@fuzzy.cz>
Re: jsonb and nested hstore Oleg Bartunov <obartunov@gmail.com>
adt Makefile, was Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: adt Makefile, was Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: adt Makefile, was Re: jsonb and nested hstore Alvaro Herrera <alvherre@2ndquadrant.com>
Re: adt Makefile, was Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: adt Makefile, was Re: jsonb and nested hstore Michael Paquier <michael.paquier@gmail.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andres Freund <andres@2ndquadrant.com>
Re: jsonb and nested hstore Heikki Linnakangas <hlinnakangas@vmware.com>
Re: jsonb and nested hstore - small docpatch "Erik Rijkers" <er@xs4all.nl>
Re: jsonb and nested hstore - small docpatch "Erik Rijkers" <er@xs4all.nl>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Oleg Bartunov <obartunov@gmail.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Peter Geoghegan <pg@heroku.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Hannu Krosing <hannu@2ndQuadrant.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Tom Lane <tgl@sss.pgh.pa.us>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>
Re: jsonb and nested hstore Andrew Dunstan <andrew@dunslane.net>
Re: jsonb and nested hstore Merlin Moncure <mmoncure@gmail.com>

On Feb 28, 2014, at 2:12 PM, Peter Geoghegan  wrote:

> AFAICT, we have these
> operator classes that work fine with jsonb for the purposes of
> hstore-style indexing (the hstore operator classes).

That assumes that it is acceptable that jsonb be packaged in the hstore extension.  To put it mildly, there's no consensus on that point; indeed, I think there's consensus that's a non-starter.

--
-- Christophe Pettus  xof@thebuild.com



В списке pgsql-hackers по дате отправления
От: Pavel Stehule
Дата:
От: Peter Geoghegan
Дата:
Сообщение: Re: jsonb and nested hstore
FAQ