JSONB matching element count

From: Arup Rakshit <aruprakshit(at)rocketmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: JSONB matching element count
Date: 2015-05-31 14:07:14
Message-ID: 2827087.D4OSFHZou2@linux-wzza.aruprakshit
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-05-31 14:34:17 Re: date type changing to timestamp without time zone in postgres 9.4
Previous Message Evi-M 2015-05-31 13:11:38 Help me recovery databases.