Need clarification on how to extract or compare numeric values enclosed in jsonb

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: dmytrocx75(at)gmail(dot)com
Subject: Need clarification on how to extract or compare numeric values enclosed in jsonb
Date: 2018-12-19 19:52:57
Message-ID: 154524917709.15411.10770964720458372337@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message antonov 2018-12-20 15:38:26 "$user" and SESSION_USER and CURRENT_USER
Previous Message Tom Lane 2018-12-19 15:07:51 Re: Error in example