Re: [GENERAL] JSONB matching element count

2015-05-31 Thread Michael Paquier
On Sun, May 31, 2015 at 11:07 PM, Arup Rakshit 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 u

[GENERAL] JSONB matching element count

2015-05-31 Thread Arup Rakshit
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