Need clarification on how to extract or compare numeric valuesenclosed in jsonb

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Need clarification on how to extract or compare numeric valuesenclosed in jsonb
Дата
Msg-id 154524917709.15411.10770964720458372337@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: Need clarification on how to extract or compare numeric valuesenclosed in jsonb
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/functions-json.html
Description:

A really strange behavior has been noticed when trying to extract numeric
key value from jsonb and compare it to a number
https://stackoverflow.com/questions/53841916/how-to-compare-numeric-in-postgresql-jsonb
The question is: what is the recommended (or fastest) way to do this kind of
comparisons?
The question has arisen because the way postgres processes the mentioned
comparisons is not clear, even though I've read the documentation
carefully.
Thank you!

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Error in example
Следующее
От: antonov@stdpr.ru
Дата:
Сообщение: "$user" and SESSION_USER and CURRENT_USER