4 ms·
While technically correct I assume the parent was referring to hstore [0] which has both GIST and GIN indexes as well as btree and hash for equality. With some
by shawn-butler 14y ago
While technically correct I assume the parent was referring to hstore [0] which has both GIST and GIN indexes as well as btree and hash for equality.
With some simple formatting functions (its just json after all) it's sixes to me.
[0] http://www.postgresql.org/docs/9.2/static/hstore.html http://www.postgresql.org/docs/9.2/static/hstore.html
- dbuxton 14y agohstore is great, I won't hear a word against it, but it doesn't deal with complex nested objects like JSON can (I would love to be wrong about this) - it's just a key/value store with indexing of the objects inside.
- alphadogg 14y agohttp://momjian.us/main/blogs/pgblog/2012.html#October_2_2012 http://momjian.us/main/blogs/pgblog/2012.html#October_2_2012