Re: Extract numeric filed in JSONB more effectively

From:	David Rowley <dgrowleyml(at)gmail(dot)com>
To:	Haibo Yan <tristan(dot)yim(at)gmail(dot)com>
Cc:	Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Andy Fan <zhihuifan1213(at)163(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Amit Langote <amitlangote09(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, jian he <jian(dot)universality(at)gmail(dot)com>, Chapman Flack <chap(at)anastigmatix(dot)net>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject:	Re: Extract numeric filed in JSONB more effectively
Date:	2026-04-03 06:41:21
Message-ID:	CAApHDvozyjc8Qety7_aWeLaiNWGs59vBSoDNrNzXGgXbjL85NQ@mail.gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2023-08-01 04:38:57 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎  2023-08-01 11:03:29 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>   2023-08-01 23:33:37 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>    2023-08-02 01:05:44 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>     2023-08-03 10:04:18 from Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>      2023-08-03 12:31:34 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>      2023-08-04 03:32:04 from jian he <jian(dot)universality(at)gmail(dot)com>       2023-08-04 03:55:07 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>        2023-08-04 20:50:17 from Chapman Flack <chap(at)anastigmatix(dot)net>  2023-08-02 06:01:15 from jian he <jian(dot)universality(at)gmail(dot)com>   2023-08-03 00:50:47 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎    2023-08-03 04:59:19 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>     2023-08-03 07:53:47 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>      2023-08-03 09:47:33 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>       2023-08-03 13:22:48 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>        2023-08-03 13:52:40 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>         2023-08-03 14:27:34 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>          2023-08-03 19:13:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>           2023-08-04 04:38:23 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>            2023-08-07 03:04:05 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎             2023-08-07 06:19:48 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>              2023-08-07 07:32:25 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎               2023-08-07 09:36:40 from jian he <jian(dot)universality(at)gmail(dot)com>                2023-08-07 11:51:18 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                 2023-08-08 02:28:18 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                 2023-08-08 20:30:10 from Chapman Flack <chap(at)anastigmatix(dot)net>                  2023-08-09 07:46:03 from jian he <jian(dot)universality(at)gmail(dot)com>                  2023-08-10 08:03:15 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎           2023-08-14 07:06:30 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>            2023-08-14 08:01:31 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>             2023-08-14 09:16:52 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>              2023-08-14 12:54:22 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>            2023-08-14 14:04:03 from Chapman Flack <chap(at)anastigmatix(dot)net>             2023-08-14 14:10:14 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>              2023-08-14 15:42:12 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎               2023-08-15 03:24:35 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎                2023-08-15 05:23:26 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>                 2023-08-15 05:33:03 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>                 2023-08-15 06:04:19 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                  2023-08-15 06:50:25 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>                   2023-08-15 07:05:26 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                    2023-08-15 07:45:59 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>                 2023-08-16 06:12:16 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎                  2023-08-16 06:27:57 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎                   2023-08-16 16:32:08 from jian he <jian(dot)universality(at)gmail(dot)com>                    2023-08-17 09:07:31 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎                     2023-08-17 20:30:41 from Chapman Flack <chap(at)anastigmatix(dot)net>                      2023-08-18 01:14:27 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                       2023-08-18 02:55:56 from Chapman Flack <chap(at)anastigmatix(dot)net>                        2023-08-18 05:02:55 from jian he <jian(dot)universality(at)gmail(dot)com>                        2023-08-18 07:41:13 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎                         2023-08-18 18:50:15 from Chapman Flack <chap(at)anastigmatix(dot)net>                          2023-08-18 19:08:57 from Chapman Flack <chap(at)anastigmatix(dot)net>                           2023-08-18 21:02:52 from Chapman Flack <chap(at)anastigmatix(dot)net>                            2023-08-21 10:58:05 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                           2023-08-21 01:31:56 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎                            2023-08-21 03:19:47 from Chapman Flack <chap(at)anastigmatix(dot)net>                             2023-08-22 03:14:48 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎                              2023-08-22 05:54:27 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                               2023-08-22 12:16:02 from Chapman Flack <chap(at)anastigmatix(dot)net>                                2023-08-26 22:28:17 from Chapman Flack <chap(at)anastigmatix(dot)net>                                 2023-08-30 04:47:35 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                                  2023-08-30 13:47:53 from Chapman Flack <chap(at)anastigmatix(dot)net>                                   2023-08-31 09:10:39 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎                                    2023-09-01 03:09:22 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎                                     2023-09-02 01:25:37 from jian he <jian(dot)universality(at)gmail(dot)com>                                      2023-09-04 11:43:50 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                                       2023-09-04 14:35:16 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎                                        2023-09-05 12:51:01 from jian he <jian(dot)universality(at)gmail(dot)com>                                         2023-09-06 07:00:00 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                                        2023-09-13 21:18:16 from Chapman Flack <chap(at)anastigmatix(dot)net>                                         2023-09-14 06:41:36 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                                          2023-09-15 01:53:20 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com> 📎                                           2023-10-05 06:53:05 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>                                            2023-11-01 02:17:24 from Chapman Flack <chap(at)anastigmatix(dot)net>                                             2023-11-02 14:21:02 from John Naylor <johncnaylorls(at)gmail(dot)com>                                             2023-11-06 03:26:28 from zhihuifan1213(at)163(dot)com 📎                                              2024-01-02 08:18:00 from jian he <jian(dot)universality(at)gmail(dot)com>                                               2024-01-07 07:17:16 from Andy Fan <zhihuifan1213(at)163(dot)com>                                                2024-01-08 00:00:00 from jian he <jian(dot)universality(at)gmail(dot)com> 📎                                                 2024-02-09 09:05:21 from Andy Fan <zhihuifan1213(at)163(dot)com> 📎                                                  2024-03-04 12:33:12 from Peter Eisentraut <peter(at)eisentraut(dot)org>                                                   2024-03-04 16:14:43 from Andy Fan <zhihuifan1213(at)163(dot)com>                                                    2024-03-09 23:16:40 from Andy Fan <zhihuifan1213(at)163(dot)com>                                                     2024-04-01 01:42:12 from Andy Fan <zhihuifan1213(at)163(dot)com> 📎                                                      2024-04-17 05:13:34 from Andy Fan <zhihuifan1213(at)163(dot)com> 📎                                                       2024-09-11 21:00:41 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                                                        2024-09-12 03:03:18 from Andy Fan <zhihuifan1213(at)163(dot)com>                                                         2024-11-15 16:30:09 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                                          2024-11-18 00:23:52 from Andy Fan <zhihuifan1213(at)163(dot)com>                                                           2024-11-22 18:14:25 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                                            2026-04-03 04:46:22 from Haibo Yan <tristan(dot)yim(at)gmail(dot)com> 📎                                                             2026-04-03 04:50:27 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>                                                             2026-04-03 06:41:21 from David Rowley <dgrowleyml(at)gmail(dot)com>                                                              2026-04-03 16:37:22 from Haibo Yan <tristan(dot)yim(at)gmail(dot)com>                                                              2026-04-03 16:42:20 from Haibo Yan <tristan(dot)yim(at)gmail(dot)com>          2023-08-04 03:54:15 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>      2023-08-03 12:34:44 from Chapman Flack <chap(at)anastigmatix(dot)net>       2023-08-03 13:50:15 from Andy Fan <zhihui(dot)fan1213(at)gmail(dot)com>
Lists:	pgsql-hackers

In response to

• Re: Extract numeric filed in JSONB more effectively at 2026-04-03 04:46:22 from Haibo Yan

Responses

• Re: Extract numeric filed in JSONB more effectively at 2026-04-03 16:37:22 from Haibo Yan
• Re: Extract numeric filed in JSONB more effectively at 2026-04-03 16:42:20 from Haibo Yan

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Andrei Lepikhov	2026-04-03 06:42:58	Flaky test in t/100_vacuumdb.pl: ordering assumption not stable under plan changes
Previous Message	Fujii Masao	2026-04-03 06:13:39	Re: Exit walsender before confirming remote flush in logical replication