Re: correct format for date, time, timestamp for XML functionality

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: correct format for date, time, timestamp for XML functionality
Дата
Msg-id BAY20-F50271C54E49BE7CBA43C6F9890@phx.gbl
обсуждение исходный текст
Ответ на Re: correct format for date, time, timestamp for XML functionality  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: correct format for date, time, timestamp for XML functionality  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-patches


>From: Andrew Dunstan <andrew@dunslane.net>
>To: Peter Eisentraut <peter_e@gmx.net>
>CC: Pavel Stehule <pavel.stehule@hotmail.com>,
>pgsql-patches@postgresql.org
>Subject: Re: [PATCHES] correct format for date, time, timestamp for XML
>functionality
>Date: Tue, 20 Feb 2007 11:37:31 -0500
>
>Peter Eisentraut wrote:
>>Am Dienstag, 20. Februar 2007 16:54 schrieb Andrew Dunstan:
>>
>>>I'm not sure that we are actually guaranteeing anything about XML
>>>validity against any schema or DTD, are we?
>>>
>>
>>That is the "xmlschema" part of table_to_xmlschema() et al. recently
>>discussed.  That entire functionality hinges on producing output that
>>validates against XML Schema schemas, and so we cannot pick the data type
>>formats outselves.
>>
>>
>Then why would we use a setting to govern this? Should we not simply ensure
>that we always output timestamps in XML using the correct ISO8601 format?
>
xsd knows datetime type. You can inherit it, and then you have to respect
it. You can do own type, but you lost information, and any general scripts
don't understand. I don't know why xsd doesn't iso format, but its simply
fact. Please read this discussion:
http://forums.oracle.com/forums/thread.jspa?threadID=467278&tstart=0

>cheers
>
>andrew

_________________________________________________________________
Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: correct format for date, time, timestamp for XML functionality
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Fast CLUSTER