I take that back, basic JSON support was introduced in PostgreSQL 9.2, and a back-port of its functionality is also available for 9.1 here: https://bitbucket.org/adunstan/json_91
On Thu, Jan 2, 2014 at 4:04 PM, Joshua D. Burns <joshuadburns@xxxxxxxxxxx> wrote:
For information which is sure to be up to date, check out: http://www.postgresql.org/download/linux/debian/They describe how to add the repo to your Debian install, allowing you to update to PostgreSQL 9.3+.
The JSON data type was implemented in 9.3. 9.4 (still under development,) brings some HUGE enhancements to the storage mechanism behind HSTORE and JSON, which I'd hop on the moment it is released as stable.
On Thu, Jan 2, 2014 at 3:37 PM, Raymond O'Donnell <rod@xxxxxx> wrote:
On 02/01/2014 19:19, john.tiger wrote:Dunno about the JSON question, but you can get current Debian versions
> trying to select a row of json type returning the entire json record
>
> table users id, jsondata
> jsondata has {"username":"jdoe", ....}
>
> select json_to_row from users where jsondata->"username" = "jdoe";
> fails on operator -> unknown
>
> using debian testing with postgresql backport ppa
> psql: 9.3.2 server 9.2.6
>
> do I need a higher server version ? is there a 9.3 server available for
> debian ?
of PostgreSQL from http://apt.postgresql.org.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@xxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
