2010/12/14 Andrew Dunstan <andrew@dunslane.net>:
> On 12/14/2010 12:06 PM, Robert Haas wrote:
>>>
>>> I haven't actually figured out what the benefit would be, other than
>>> buzzword compliance and a chance to invent some random nonstandard
>>> syntax. If the element values all have to be the same type, you've
>>> basically got hstore.
>>
>> Not exactly, because in hstore all the element values have to be,
>> specifically, text. Having hstores of other kinds of objects would,
>> presumably, be useful.
>>
>
> I love hstore, and I've used it a lot, but I don't think there's much future
> in doing this. This is part of what JSON would buy us, isn't it?
Well, JSON would give you numbers and booleans, but that's a pretty
small subset of all the types in the universe. I think the main thing
JSON would give you is hierarchical structure.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company