Re: Typed hstore proposal

Christopher Browne <cbbrowne@gmail.com> writes:

> On Wed, Dec 21, 2011 at 8:32 PM, Johann 'Myrkraverk' Oskarsson
> <johann@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
andServices  --+--                                                                 |  Blog:
http://my.opera.com/myrkraverk/blog/