Postgres Pro
Downloads
Home   >   mailing lists

Thread: json data type

json data type

From
Armand Turpel
Date:
Hi,

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?

Thanks,
atu



#####################################################################################
Scanned by MailMarshal - Marshal's comprehensive email content security solution.
#####################################################################################

Re: json data type

From
Mike Christensen
Date:
> 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?

I actually store a pretty good amount of JSON serialized data for my
website, kitchenpc.com which uses Postgres 9.0.  I don't have any
problems with this, I just use a text data type.  I'd be interested in
knowing what functionality would come with a JSON data type, like
could you query for all rows with an X property of > 5 or something,
eg {Y: 1, X: 6}

Mike

Re: json data type

From
Armand Turpel
Date:
On 23/11/2010 09:34, Mike Christensen wrote:
> I'd be interested in
> knowing what functionality would come with a JSON data type, like
> could you query for all rows with an X property of>  5 or something,
> eg {Y: 1, X: 6}

Yes, as far as i know, you can make queries on json content

#####################################################################################
Scanned by MailMarshal - Marshal's comprehensive email content security solution.
#####################################################################################

Re: json data type

From
Tom Lane
Date:
Armand Turpel <aturpel@mnhn.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