Re: proposal: jsonb_populate_array - Mailing list pgsql-hackers

From jian he
Subject Re: proposal: jsonb_populate_array
Date
Msg-id CACJufxHYca4cbYnc93d-VuLPbhGKJV4KogRCTG=TLRc6O86DQw@mail.gmail.com
Whole thread Raw
In response to Re: proposal: jsonb_populate_array  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: proposal: jsonb_populate_array
List pgsql-hackers
\df jsonb_populate_record
                                 List of functions
   Schema   |         Name          | Result data type | Argument data
types | Type
------------+-----------------------+------------------+---------------------+------
 pg_catalog | jsonb_populate_record | anyelement       | anyelement,
jsonb   | func
(1 row)

manual:
> anyelement  Indicates that a function accepts any data type.
> For the “simple” family of polymorphic types, the matching and deduction rules work like this:
> Each position (either argument or return value) declared as anyelement is allowed to have any specific actual data
type,but in any given call they must all be the same actual type. 

So jsonb_populate_record signature can handle cases like
jsonb_populate_record(anyarray, jsonb)? obviously this is a cast, it
may fail.
also if input is anyarray, so the output anyarray will have the same
base type as input anyarray.



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [PoC] pg_upgrade: allow to upgrade publisher node
Next
From: Andy Fan
Date:
Subject: Re: Extract numeric filed in JSONB more effectively