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