Skip site navigation (1) Skip section navigation (2)

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

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Pavel Stehule <pavel(dot)stehule(at)hotmail(dot)com>
Cc: pgsql-patches(at)postgresql(dot)org, peter_e(at)gmx(dot)net
Subject: Re: correct format for date, time, timestamp for XML functionality
Date: 2007-02-20 15:54:04
Message-ID: 45DB199C.2050301@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-patches
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


In response to

Responses

pgsql-patches by date

Next:From: Magnus HaganderDate: 2007-02-20 16:04:36
Subject: Re: correct format for date, time, timestamp for XML functionality
Previous:From: markDate: 2007-02-20 15:47:43
Subject: Re: [HACKERS] HOT WIP Patch - version 2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group