Re: Duplicate JSON Object Keys

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: Duplicate JSON Object Keys
Дата
Msg-id 9A4E6ABE-1495-46B7-8C1A-7C5B675F410E@justatheory.com
обсуждение исходный текст
Ответ на Re: Duplicate JSON Object Keys  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: Duplicate JSON Object Keys  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
On Mar 13, 2013, at 10:45 AM, Andrew Dunstan <andrew@dunslane.net> wrote:

> If someone wants functions to enforce a stricter validity check (e.g. via a check constraint on a domain), or to
convertjson to a canonical version which strips out prior keys of the same name and their associated values, then these
shouldbe relatively simple to implement given the parser API in the current patch. But they aren't part of the current
patch,and I think it's way too late to be adding such things. 

I think it might be good to get something like this into core eventually, otherwise I suspect that there will be a
differentversion of it for every JSON-using project out there. And my first cut at it won’t descend into sub-objects. 

> I have been persuaded by arguments made upthread that the best thing to do is exactly what other well known
json-acceptingimplementations do (e.g. V8), which is to accept json with duplicate keys and to treat the later
key/valueas overriding the former key/value. If I'd done that from the start nobody would now be talking about this at
all.

That’s true, though I might have started thinking about a canonicalizing function before long. :-)

Best,

David




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Duplicate JSON Object Keys
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Duplicate JSON Object Keys