=?UTF-8?B?VG9yc3RlbiBGw7ZydHNjaA==?= <torsten.foertsch@gmx.net> writes:
> On 25/02/15 07:34, David G Johnston wrote:
>> Torsten Förtsch wrote
>>> Is there anything similar for JSON scalars?
>> IDK, but have you tried "::text"?
> yes. Here is the difference
> select * from (values (('{"a":"b"}'::json -> 'a')::text),
> ('{"a":"b"}'::json ->> 'a')) t;
> column1
> ---------
> "b"
> b
As of 9.4, there's a function json_array_elements_text()
which does what I think you're looking for.
regards, tom lane