| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, jian he <jian(dot)universality(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Extract numeric filed in JSONB more effectively |
| Date: | 2023-08-14 12:54:22 |
| Message-ID: | CAFj8pRAfBYLbaVHvcFwHeDy2zakKCb=jtWde5AXgMRL3pw0iMg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
po 14. 8. 2023 v 11:17 odesílatel Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>
napsal:
>
>> you cannot to use type as parameter. There should be some typed value -
>> like
>>
>> jsonb_object_field, '{"a":10}', 'a', NULL::int)
>>
>> and return type should be anyelement.
>>
>>
> So could we get the inputted type in the body of jsonb_object_field?
> I guess no. IIUC, our goal will still be missed in this way.
>
why not? You can easily build null constant of any type.
>
> --
> Best Regards
> Andy Fan
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2023-08-14 12:58:07 | Re: Wrong rows estimations with joins of CTEs slows queries by more than factor 500 |
| Previous Message | Pavel Stehule | 2023-08-14 12:51:43 | Re: proposal: jsonb_populate_array |