Re: PATCH: Add hstore_to_json() - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PATCH: Add hstore_to_json()
Date
Msg-id 9841.1261164356@sss.pgh.pa.us
Whole thread Raw
In response to Re: PATCH: Add hstore_to_json()  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: PATCH: Add hstore_to_json()  (Andrew Dunstan <andrew@dunslane.net>)
Re: PATCH: Add hstore_to_json()  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> You're correct that we don't necessarily need a new type, we could just 
> make it text and have a bunch of operations, but that seems to violate 
> the principle of data type abstraction a bit.

I think the relevant precedent is that we have an xml type.  While I
surely don't want to follow the SQL committee's precedent of inventing
a ton of special syntax for xml support, it might be useful to look at
that for suggestions of what functionality would be useful for a json
type.

[ I can already hear somebody insisting on a yaml type :-( ]
        regards, tom lane


pgsql-hackers by date:

Previous
From: jesus@omniti.com
Date:
Subject: Re: question about implementing XA-ish functions
Next
From: Bruce Momjian
Date:
Subject: Removing pg_migrator limitations