Re: JSON query help

Поиск
Список
Период
Сортировка
От Gavin Henry
Тема Re: JSON query help
Дата
Msg-id CAA8_NKCgfqgyjJ2L4BqHQ7QwLy1JjFoXnzQ_yeYEgppieqAD-w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: JSON query help  (Gavin Henry <gavin.henry@gmail.com>)
Ответы Re: JSON query help
Список pgsql-novice
Дерево обсуждения 
Thanks, that worked! Now I need to go back to basics and SETS:

SELECT
cost_details->'Accounting'->jsonb_object_keys(cost_details->'Accounting')->'BalanceUUID'
AS BalanceUUID,
cost_details->'Accounting'->jsonb_object_keys(cost_details->'Accounting')->'Units'
AS Cost
FROM cdrs
WHERE cost > 0
AND cost_details->'AccountSummary'->'BalanceSummaries' @>
'[{"ID":"B_MONETARY_POSTPAID"}]'
AND cost_details->'AccountSummary'->'BalanceSummaries' @>
json_build_object('UUID',
cost_details->'Accounting'->jsonb_object_keys(cost_details->'Accounting')->'BalanceUUID')::jsonb
limit 1;
ERROR:  argument of AND must not return a set
LINE 1: ...ummaries' @> '[{"ID":"B_MONETARY_POSTPAID"}]' AND cost_detai...

В списке pgsql-novice по дате отправления: