Why no jsonb_exists_path()?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Why no jsonb_exists_path()?
Date: 2015-06-09 18:16:47
Message-ID: 55772D8F.4070303@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Dmitry, Alexander:

I'm noticing a feature gap for JSONB operators; we have no way to do this:

jsonb_col ? ARRAY['key1','key2','key3']

... that is, there is no way for us to check for key existence in an
indexable fashion. Given that @> already can check the whole path
including the value, is there some challenge to stopping just short of
the value I'm not seeing? Or is this just a "didn't get to it yet" issue?

I'm trying to estimate the difficulty of creating this operator in an
extension (obviously we're not doing it for 9.5), and maybe for 9.6.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2015-06-09 18:40:10 Re: Why no jsonb_exists_path()?
Previous Message Alvaro Herrera 2015-06-09 17:51:19 Re: Draft release notes for 9.4.4 et al