Hacker News Reader

JSON support in Postgres is currently limited to a validated plain text field, it doesn't let you efficiently query inside the json object.

View on HN

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

hstore 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.

There's nothing stopping you from writing functions that can index json documents. plv8 makes this easy.

Reply on news.ycombinator.com