Обсуждение: json data type
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. #####################################################################################
> 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
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. #####################################################################################
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