On 9/24/12 10:26 PM, Andrew Dunstan wrote: > Well, an obvious case is how record_to_json handles fields. If it knows > nothing about the type all it can do is output the string value. That > doesn't work well for types such as hstore. If it could reliably > recognize a field as an hstore it might well be able to do lots better.
I think the fix there is that the type supplies a "to JSON" function as part of its type definition (just like input and output functions). "to XML" would also be useful. Most types wouldn't need them and default to string output. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers