Re: [PATCHES] correct format for date, time, timestamp for XML functionality

2007-03-01 Thread Peter Eisentraut
Pavel Stehule wrote: 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. I've installed this patch and made some additional adjustments so the time zone format matches the XSD

Re: [PATCHES] correct format for date, time, timestamp for XML functionality

2007-02-26 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. ---

[PATCHES] correct format for date, time, timestamp for XML functionality

2007-02-20 Thread Pavel Stehule
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: -mm-dd hh24:mi:ss XSD: -mm-ddThh24:mi:ss I found one link about this topic:

Re: [PATCHES] correct format for date, time, timestamp for XML functionality

2007-02-20 Thread Tom Lane
Pavel Stehule [EMAIL PROTECTED] writes: 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: -mm-dd hh24:mi:ss XSD: -mm-ddThh24:mi:ss

Re: [PATCHES] correct format for date, time, timestamp for XML functionality

2007-02-20 Thread Pavel Stehule
Pavel Stehule [EMAIL PROTECTED] writes: 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: -mm-dd hh24:mi:ss XSD:

Re: [PATCHES] correct format for date, time, timestamp for XML functionality

2007-02-20 Thread Andrew Dunstan
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: -mm-dd hh24:mi:ss XSD: -mm-ddThh24:mi:ss Pavel, I

Re: [PATCHES] correct format for date, time, timestamp for XML functionality

2007-02-20 Thread Andrew Dunstan
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: -mm-dd hh24:mi:ss XSD:

Re: [PATCHES] correct format for date, time, timestamp for XML functionality

2007-02-20 Thread Magnus Hagander
On Tue, Feb 20, 2007 at 04:32:28PM +0100, Pavel Stehule wrote: 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

Re: [PATCHES] correct format for date, time, timestamp for XML functionality

2007-02-20 Thread Pavel Stehule
I'm not sure that we are actually guaranteeing anything about XML validity against any schema or DTD, are we? what? ofcourse you cannot garant validity against any schema. But mapping functions are standardised and expect xsd. And I what I can meet protocols based on xml, they respect xsd

Re: [PATCHES] correct format for date, time, timestamp for XML functionality

2007-02-20 Thread Pavel Stehule
On Tue, Feb 20, 2007 at 04:32:28PM +0100, Pavel Stehule wrote: 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

Re: [PATCHES] correct format for date, time, timestamp for XML functionality

2007-02-20 Thread Peter Eisentraut
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

Re: [PATCHES] correct format for date, time, timestamp for XML functionality

2007-02-20 Thread Andrew Dunstan
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

Re: [PATCHES] correct format for date, time, timestamp for XML functionality

2007-02-20 Thread Pavel Stehule
From: Andrew Dunstan [EMAIL PROTECTED] To: Peter Eisentraut [EMAIL PROTECTED] CC: Pavel Stehule [EMAIL PROTECTED], 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

Re: [PATCHES] correct format for date, time, timestamp for XML functionality

2007-02-20 Thread Andrew Dunstan
Pavel Stehule wrote: 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: