On 09/29/2012 10:29 PM, Andrew Dunstan wrote:
On 09/29/2012 05:01 PM, Hannu Krosing wrote:
On 09/29/2012 05:40 PM, Andrew Dunstan wrote:
I still think Tom's suggestion is the best and simplest way to do that.
which Toms suggestion you mean here ?
The 3. mentioned above was for making possible 2 separate ways to
convert (serialise/quote/escape and parse/check-for-valid-json)
string to json and afair not about hstore to json.
Er, what? yes, I meant option 3, and it is a perfect mechanism for
doing conversion of an hstore field inside datum_to_json: the code
would look for a cast to the new type (whatever we call it) and use
that instead of the normal text representation.
The only place where the new type is needed is text to json conversion,
for all others cast to the main json type should be enough.
Or do you mean to still do it as a generic cast to "json_component" type
so it would be usable for text types as well ?
I'm also looking forward for an easy way or two to populate a record
from json and extract an array from json.
I am prepared to take this on - at least starting with json to array
which I think is the simpler case. I have some ideas about how to do
this and have done a bit of experimental work along these lines.
Personally I'd be inclined to make it do a conversion to text[] and
then cast from that to anything else we needed.
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
