Re: correct format for date, time, timestamp for XML functionality - Mailing list pgsql-patches

From Pavel Stehule
Subject Re: correct format for date, time, timestamp for XML functionality
Date
Msg-id BAY20-F50271C54E49BE7CBA43C6F9890@phx.gbl
Whole thread Raw
In response to Re: correct format for date, time, timestamp for XML functionality  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: correct format for date, time, timestamp for XML functionality
List 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 by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: correct format for date, time, timestamp for XML functionality
Next
From: Alvaro Herrera
Date:
Subject: Re: Fast CLUSTER