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

Pavel Stehule wrote:
>
>> Pavel Stehule wrote:
>>> Hello,
>>>
>>> this patch ensures independency datetime fields on current datestyle 
>>> setting. Add new internal datestyle USE_XSD_DATESTYLE. It's almoust 
>>> same to USE_ISO_DATESTYLE. Differences are for timestamp:
>>>
>>> ISO: yyyy-mm-dd hh24:mi:ss
>>> XSD: yyyy-mm-ddThh24:mi:ss
>>>
>>>
>>
>>
>> Pavel,
>>
>> I agree that we should have some support for XSD date style so that 
>> we can produce validatable XML documents. In fact I had to make just 
>> such a transformation on data pulled from Postgres recently in 
>> application code to get a document to validate.
>>
>> However, I have not seen this topic discussed on -hackers. The way we 
>> work is that ideas about features should be discussed there before 
>> you submit a patch. For one thing, -hackers has a somewhat wider set 
>> of readers than -patches. Also, you might well get good ideas about 
>> any likely difficulties. Just lobbing a patch for an undiscussed 
>> feature over the wall like this is not good practice. You should get 
>> signoff on the idea before you start coding, even for fairly small 
>> changes.
>>
>
> I am sorry. I reported this two times before. This patch is related 
> only for xml functionality. XSD datestyle is only one internal 
> constant. There are no new datestyle (I hope so can be usefull). My 
> patch is small bug fix like Peter's patch for boolean datatype. 
> Generating invalid xml is bug not feature, no?
>
> Primary I had to send this patch to Peter.
>
>

I'm not sure that we are actually guaranteeing anything about XML 
validity against any schema or DTD, are we?

If there was previous email I apologise, as I didn't find it when I 
looked. Perhaps in such cases you could include a ref to the archive URL.

cheers

andrew