On Tue, Aug 1, 2023 at 7:03 PM Matthias van de Meent < boekewurm+postg...@gmail.com> wrote:
> On Tue, 1 Aug 2023 at 06:39, Andy Fan <zhihui.fan1...@gmail.com> wrote: > > > > Hi: > > > > Currently if we want to extract a numeric field in jsonb, we need to use > > the following expression: cast (a->>'a' as numeric). It will turn a > numeric > > to text first and then turn the text to numeric again. > > Why wouldn't you use cast(a->'a' as numeric), or ((a->'a')::numeric)? > Thanks for this information! I didn't realize we have this function already at [1]. https://www.postgresql.org/docs/15/functions-json.html -- Best Regards Andy Fan
