Re: json indexing and data types

From: Kaare Rasmussen <kaare(at)jasonic(dot)dk>
To: <obartunov(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: json indexing and data types
Date: 2015-12-16 04:34:25
Message-ID: 5670E9D1.10905@jasonic.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 <http://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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Savenko 2015-12-16 04:54:41 Re: How to get the size of JSONB in bytes?
Previous Message Joe Conway 2015-12-16 04:26:41 Re: dblink_connect fails