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
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@iol.ie> wrote:
On 02/01/2014 19:19, john.tiger wrote: > 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 ?
Dunno about the JSON question, but you can get current Debian versions of PostgreSQL from http://apt.postgresql.org.
Ray.
-- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie