Re: 9.4 release notes - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: 9.4 release notes
Date
Msg-id CAM3SWZRYTs8USeE4_LciikXi1snLYoR8-E+oXpzBGcv59tNLCw@mail.gmail.com
Whole thread Raw
In response to Re: 9.4 release notes  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: 9.4 release notes  (Bruce Momjian <bruce@momjian.us>)
Re: 9.4 release notes  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Mon, May 5, 2014 at 8:28 AM, Andrew Dunstan <andrew@dunslane.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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: TABLESPACE and directory for Foreign tables?
Next
From: Andres Freund
Date:
Subject: Re: avoiding tuple copying in btree index builds