Re: potential bug in JSON - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: potential bug in JSON
Date
Msg-id 51A4D2F4.9010107@agliodbs.com
Whole thread Raw
In response to potential bug in JSON  (Szymon Guz <mabewlun@gmail.com>)
Responses Re: potential bug in JSON
List pgsql-hackers
On 05/28/2013 08:38 AM, Szymon Guz wrote:
> I've found a potential bug. Why the "->" operator returns JSON instead of
> TEXT? It doesn't make sens for me, and the documentation doesn't inform
> about that.

Yes, it most certainly does:
http://www.postgresql.org/docs/9.3/static/functions-json.html

If you want to get text, use the ->> operator.


-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: potential bug in JSON
Next
From: Andres Freund
Date:
Subject: Re: Extent Locks