4 ms·

If you need to query JSON content, why to store it like plain string, to begin with? Parse it at application level (or even in stored procedure) and store like

by snaky 13y ago

If you need to query JSON content, why to store it like plain string, to begin with? Parse it at application level (or even in stored procedure) and store like ordinary fields. Or use hstore.

kanja 13y ago
Postgres additionally has a json field type.
- snaky 13y ago
  That is for now, until PostgreSQL 9.3 released, have only one useful feature comparing to plain string - validation. That's not much help, and that original lmm's point was about.