JSONB matching element count - Mailing list pgsql-general

From Arup Rakshit
Subject JSONB matching element count
Date
Msg-id 2827087.D4OSFHZou2@linux-wzza.aruprakshit
Whole thread Raw
Responses Re: JSONB matching element count  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Hi,

This says if matched found or not against the input array :

'{"a":1, "b":2, "c":3}'::jsonb ?| array['b', 'c']

But how would I determine how many matched ? Like for the above example, I see only 2 matched found.

--
================
Regards,
Arup Rakshit
================
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as
possible,you are, by definition, not smart enough to debug it. 

--Brian Kernighan


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: date type changing to timestamp without time zone in postgres 9.4
Next
From: Tom Lane
Date:
Subject: Re: Curious case of huge simple btree indexes bloat.