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