2 ms·
JSON support in Postgres is currently limited to a validated plain text field, it doesn't let you efficiently query inside the json object.
by tcwc 14y ago
JSON support in Postgres is currently limited to a validated plain text field, it doesn't let you efficiently query inside the json object.
- shawn-butler 14y agoWhile 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
- joevandyk 14y agoThere's nothing stopping you from writing functions that can index json documents. plv8 makes this easy.