Re: Extract numeric filed in JSONB more effectively - Mailing list pgsql-hackers

From jian he
Subject Re: Extract numeric filed in JSONB more effectively
Date
Msg-id CACJufxHv+Yo+ivq5u+cjo9Fa=SyfvA-V4CLePuS0JgLiC-yCBQ@mail.gmail.com
Whole thread Raw
In response to Re: Extract numeric filed in JSONB more effectively  (Chapman Flack <chap@anastigmatix.net>)
List pgsql-hackers
On Fri, Aug 18, 2023 at 10:55 AM Chapman Flack <chap@anastigmatix.net> wrote:
>
>
> Again, all of that complication stems from the choice to use the
> anyelement return type and rely on polymorphic type resolution
> to figure the oid out, when we already have the oid to begin with
> and the oid is all we want.
>

you want jsonb_object_field_type(internal, jsonb, text)? because on
sql level, it's safe.

The return data type is determined when we are in jsonb_cast_support.
we just need to pass the {return data type} information to the next
function: jsonb_object_field_type.



pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: New WAL record to detect the checkpoint redo location
Next
From: Amit Kapila
Date:
Subject: Re: logical decoding and replication of sequences, take 2