[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] JSONB matching element count
From:       Arup Rakshit <aruprakshit () rocketmail ! com>
Date:       2015-05-31 14:19:14
Message-ID: 2827087.D4OSFHZou2 () linux-wzza ! aruprakshit
[Download RAW message or body]

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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[prev in list] [next in list] [prev in thread] [next in thread]