Re: json data type

From: Mike Christensen <mike(at)kitchenpc(dot)com>
To: Armand Turpel <aturpel(at)mnhn(dot)lu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: json data type
Date: 2010-11-23 08:34:18
Message-ID: AANLkTi=W=r05QPz5gSBO7u0hFGSZ-ZF86RVG2LnFY7vj@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2010-11-23 08:39:26 Re: finding rows with invalid characters
Previous Message Armand Turpel 2010-11-23 07:54:29 json data type