Re: JSON for PG 9.2 - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: JSON for PG 9.2
Date
Msg-id 4EE671CE.6010304@dunslane.net
Whole thread Raw
In response to Re: JSON for PG 9.2  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: JSON for PG 9.2  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

On 12/12/2011 03:54 PM, Robert Haas wrote:
> On Mon, Dec 12, 2011 at 3:38 PM, Simon Riggs<simon@2ndquadrant.com>  wrote:
>> Rather than fuss with specific data formats, why not implement
>> something a little more useful?
>>
>> At present we can have typmods passed as a cstring, so it should be
>> possible to add typmods onto the TEXT data type.
>>
>> e.g. TEXT('JSON'), TEXT('JSONB')
>>

[...]
>    There are way too many places that assume that the typmod can
> just be discarded.  I don't think that's going to fly, because
> =(text,text) probably has different semantics from =(json,json).
>

And certain places where they are not allowed at all, I think (unless I 
am misremembering the early debates about enum types and output functions).

cheers

andrew


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is anybody actually using XLR_BKP_REMOVABLE?
Next
From: Josh Berkus
Date:
Subject: Re: JSON for PG 9.2