Postgres Pro
Downloads
Home   >   mailing lists

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

From Andy Fan
Subject Re: Extract numeric filed in JSONB more effectively
Date
Msg-id CAKU4AWqa78Ue9+od9P3SkrtOsahU8UsXqNMRw9UwyNyJh_BWDA@mail.gmail.com
Whole thread Raw
In response to Re: Extract numeric filed in JSONB more effectively  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Extract numeric filed in JSONB more effectively
List pgsql-hackers
Tree view

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. 

--
Best Regards
Andy Fan

pgsql-hackers by date:

Previous
From: Masahiro Ikeda
Date:
Subject: Re: Support to define custom wait events for extensions
Next
From: Nikita Malakhov
Date:
Subject: Re: POC: Extension for adding distributed tracing - pg_tracing