Hacker News Reader

Actually, Postgres does have a JSON datatype. The only extra thing it does is ensure the data is valid JSON, but it is still technically incorrect to say that there is no JSON type.

http://www.postgresql.org/docs/devel/static/datatype-json.ht...

View on HN

Dang. Yeah - Definitely should have said there's not JSON type known to Node PG, which is actually incorrect as of this morning: https://github.com/brianc/node-postgres/pull/239

Thanks for pointing out the error!

> The only extra thing it does is ensure the data is valid JSON,

Even that's actually not quite fair, it has special syntax for queries within the JSON (->> etc), and a bunch of functions: http://www.postgresql.org/docs/devel/static/functions-json.h...

These functions can be run on datatypes other than JSON, but yes, you are correct.

Reply on news.ycombinator.com