Re: json casts

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: json casts
Дата
Msg-id 5384EE0C.3000605@vmware.com
обсуждение исходный текст
Ответ на json casts  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: json casts
Список pgsql-hackers
On 05/27/2014 10:53 PM, Andrew Dunstan wrote:
> I've been on the receiving end of a couple of mumbles about the fact
> that the JSON rendering code ignores casts of builtin types to JSON.
> This was originally done as an optimization to avoid doing cache lookups
> for casts for things we knew quite well how to turn into JSON values
> (unlike, say, hstore). However, there is at least one concrete case
> where this has some possibly undesirable consequences, namely
> timestamps. Many JSON processors, especially JavaScript/ECMAScript
> processors, require timestamp values to be in ISO 8601 format, with a
> 'T' between the date part and the time part, and thus they barf on the
> output we produce for such values.

I don't understand what ignoring casts of builtin types to JSON means. 
Can you give an example?

- Heikki



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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: json casts
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: json casts