On 02/26/2014 07:02 AM, Merlin Moncure wrote: > On Tue, Feb 25, 2014 at 3:57 PM, Hannu Krosing <ha...@2ndquadrant.com> wrote: >> It is not in any specs, but nevertheless all major imlementations do it and >> some code depends on it. >> IIRC, this behaviour is currently also met only by json and not by jsonb. > > Yes: This was the agreement that was struck and is the main reason why > there are two json types, not one. JSON does not guarantee field > ordering as I read the spec and for the binary form ordering is not > maintained as a concession to using the hstore implementation.
Actually, that's not true; neither Mongo/BSON nor CouchDB preserve field ordering. So users who are familiar with JSONish data *storage* should be aware that field ordering is not preserved. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers