Re: 9.4 release notes
От | Bruce Momjian |
---|---|
Тема | Re: 9.4 release notes |
Дата | |
Msg-id | 20140505183101.GL29541@momjian.us обсуждение исходный текст |
Ответ на | Re: 9.4 release notes (Peter Geoghegan <pg@heroku.com>) |
Ответы |
Re: 9.4 release notes
|
Список | pgsql-hackers |
On Mon, May 5, 2014 at 10:58:57AM -0700, Peter Geoghegan wrote: > 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. How about: JSONB values are also mapped to SQL scalar data types, rather than being treated always as strings. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +
В списке pgsql-hackers по дате отправления: