Re: json indexing and data types

Kaare Rasmussen <kaare@xxxxxxxxxx> · Wed, 16 Dec 2015 05:34:25 +0100



    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