Re: json indexing and data types

Поиск
Список
Период
Сортировка
От Kaare Rasmussen
Тема Re: json indexing and data types
Дата
Msg-id 5670E9D1.10905@jasonic.dk
обсуждение исходный текст
Ответ на Re: json indexing and data types  (Oleg Bartunov <obartunov@gmail.com>)
Список pgsql-general
Hi Oleg

This is known problem, that's why we stop developing jsquery and are working on sql-level query language for jsonb, then you'll use all power and extendability of SQL.  The idea is to use power of subselects and unnest to unroll jsonb to sql level.
There is presentation at pgconf.eu on this
https://wiki.postgresql.org/images/4/4e/Createam.pdf, see slide #27

This is very interesting. Thanks for the update. And to all who answered this topic, sorry for awoling. I just got busy, but thanks for all the replies, I got something to think about.

But I'm afraid it'll come to 9.6.

I'll hope it comes in 9.6. I'll definitely look forward to that.

/kaare

В списке pgsql-general по дате отправления:

Предыдущее
От: Antony Gelberg
Дата:
Сообщение: Re: Packages for Ubuntu Wily (15.10)
Следующее
От: Scott Mead
Дата:
Сообщение: Re: Does PostgreSQL support to write glusterfs by Libgfapi