Search Postgresql Archives

Re: JSON in 9.2: limitations

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 08/08/2012 03:45 AM, Merlin Moncure wrote:

Given that you can do that, if you had the ability to emit json from
an hstore the OP's problem would be trivially handled.

That's where my thinking went at first too, but there's a wrinkle with that: json represents the number 1 and the string "1" differently. hstore doesn't. The input data would need to be JSON-escaped before being added to hstore to preserve that difference - so at minimum some kind of scalar json_escape(...) function is still needed.

I was also trying to avoid the need to use *two* extensions for the job.

--
Craig Ringer

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux