On Sun, May 31, 2015 at 11:07 PM, Arup Rakshit
<aruprakshit@xxxxxxxxxxxxxx> wrote:
> 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.
You could use "?" to do the check for each individual key, and then
count how many matched...
--
Michael
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
