Re: Extract numeric filed in JSONB more effectively

Andy Fan <zhihui.fan1213@gmail.com>

From: Andy Fan <zhihui.fan1213@gmail.com>

To: jian he <jian.universality@gmail.com>

Cc: Chapman Flack <chap@anastigmatix.net>, Pavel Stehule <pavel.stehule@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2023-09-04T14:35:16Z

Lists: pgsql-hackers

Attachments

v13-0001-optimize-casting-jsonb-to-a-given-type.patch (application/octet-stream) patch v13-0001

Hi,

  v13 attached.  Changes includes:

1.  fix the bug Jian provides.
2.  reduce more code duplication without DirectFunctionCall.
3.  add the overlooked  jsonb_path_query and jsonb_path_query_first as
candidates


--
Best Regards
Andy Fan

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add trailing commas to enum definitions
- 611806cd726f 17.0 cited