Josh, On Tue, Jun 9, 2015 at 9:16 PM, Josh Berkus <j...@agliodbs.com> wrote:
> Dmitry, Alexander: > > I'm noticing a feature gap for JSONB operators; we have no way to do this: > > jsonb_col ? ARRAY['key1','key2','key3'] > What documents do you expect to match this operator? Such syntax can be interpreted in very different semantics. Checking keys only at top level, any level, sequence starting from top level ... etc. '{"key1": "value1", "key2": "value2", "key3": "value3"}' '{"key1":{ "key2": {"key3: "value"}}}' '{"key1": "value1"} '[{"key1": "value1"}, {"key2": "value2"}, {"key3": "value3"}]' ------ Alexander Korotkov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company