Re: json data type

Armand Turpel <aturpel(at)mnhn(dot)lu> writes:
> A project in which i'm involved, make use of json data type for storing
> some data sets. I have read that there is some work in progress to
> implement json datatype support in postgres. So my question is; when and
> in which version of postgres we can expect this implementation?

There's been discussion of a couple of different patches on
pgsql-hackers in the past few months --- see the archives if you want
details. AFAICT there's not yet consensus on which way to proceed.
So while it's possible there will be something of the sort in 9.1,
I wouldn't bet on it.

As was mentioned, there's nothing stopping you from storing JSON stuff
as text right now. If you have any thoughts on what you would need
expanded JSON support to actually *do*, feel free to comment in the
pgsql-hackers threads.

regards, tom lane