Christopher Browne <cbbro...@gmail.com> writes: > On Wed, Dec 21, 2011 at 8:32 PM, Johann 'Myrkraverk' Oskarsson > <joh...@2ndquadrant.com> wrote: >> I mean to create a typed hstore, called tstore for now. I'm open >> to name suggestions. It'll only support a subset of core Postgres >> types to begin with. Keys are always text, it's the value that's >> typed.
> JSON is the "thing of the day" that it would be desirable for this to > be potent enough to represent, and JSON has the following types: > > 1. Number (in practice, FLOAT) > 2. String (UTF-8) > 3. Boolean (t/f) > 4. Array (not necessarily of uniform type > 5. Object (string key, JSON value pairs, unordered) > 6. NULL > > #4 and #5 are obviously entirely more "hairy." Not so much if I extend tstore to include itself. Unless I'm mistaking the Object type. I'm not a user of JSON myself. How are people likely to use it with it? -- Johann Oskarsson http://www.2ndquadrant.com/ |[] PostgreSQL Development, 24x7 Support, Training and Services --+-- | Blog: http://my.opera.com/myrkraverk/blog/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers