| From: | Peter Geoghegan <pg(at)heroku(dot)com> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, Petr Jelinek <petr(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 9.4 release notes |
| Date: | 2014-05-05 17:58:57 |
| Message-ID: | CAM3SWZRYTs8USeE4_LciikXi1snLYoR8-E+oXpzBGcv59tNLCw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, May 5, 2014 at 8:28 AM, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
> How about:
>
> This data type allows for faster access to values in the json document
> and faster and more useful indexing of json.
We should refer to the fact that jsonb is internally typed. This isn't
all that obvious now, but it is evident for example when you sort a
set of raw scalar numeric jsonb values, which has a sane ordering (the
implementation invokes numeric_cmp()). You also get an internal,
per-number-scalar display scale, just like the numeric type proper.
I'm not all that sure about how to go about succinctly expressing
this, but clearly it's important.
--
Peter Geoghegan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2014-05-05 18:13:38 | Re: avoiding tuple copying in btree index builds |
| Previous Message | Tom Lane | 2014-05-05 17:53:46 | Re: TABLESPACE and directory for Foreign tables? |