On Mon, May 5, 2014 at 10:58:57AM -0700, Peter Geoghegan wrote: > On Mon, May 5, 2014 at 8:28 AM, Andrew Dunstan <and...@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.
How about: JSONB values are also mapped to SQL scalar data types, rather than being treated always as strings. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers