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
Torsten
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
