On 9/25/12 5:58 PM, Tom Lane wrote: > Yes ... but I really don't want to go down the path of treating those as > new type properties; it doesn't scale. (And please don't tell me that > JSON is the last word in container types and there will never be > requests for any more of these.)
Yeah, I didn't like that part either, but we only add one every five years or so. > Can we define these functions as being the cast-from-foo-to-json and > cast-from-foo-to-xml functions? That would let us use the existing cast > infrastructure to manage them. Sounds attractive, but there might be some problems in the details. For example, you can't cast scalar values to valid json values, because a valid json value can only be a dictionary or an array. If we had a flag of some kind saying "cast from foo to json, but only when part of a larger json serialization, not by itself", then it might work. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers