JSONB matching element count

Поиск
Список
Период
Сортировка
От Arup Rakshit
Тема JSONB matching element count
Дата
Msg-id 2827087.D4OSFHZou2@linux-wzza.aruprakshit
обсуждение исходный текст
Ответы Re: JSONB matching element count
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: date type changing to timestamp without time zone in postgres 9.4
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Curious case of huge simple btree indexes bloat.