4 ms·
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 t
by andrewguenther 14y ago
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.html http://www.postgresql.org/docs/devel/static/datatype-json.ht...
- JohnDotAwesome 14y agoDang. 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 https://github.com/brianc/node-postgres/pull/239 Thanks for pointing out the error!
- jvm 14y ago> 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.html http://www.postgresql.org/docs/devel/static/functions-json.h...
- andrewguenther 14y agoThese functions can be run on datatypes other than JSON, but yes, you are correct.