Re: xml queries & date format

On Thu, 11 Sep 2008, Peter Eisentraut wrote:

> Jef Peeraer wrote:
> >
> > On Thu, 11 Sep 2008, Peter Eisentraut wrote:
> >
> > > Tom Lane wrote:
> > > > Jef Peeraer <jef(dot)peeraer(at)telenet(dot)be> writes:
> > > > > i am using the xml add-ons, but the date output format seems to be
> > > > > wrong :
> > > > I think the conversion to xml intentionally always uses ISO date format,
> > > > because that's required by some spec somewhere.
> > > Yes, it follows XML Schema. Which is why the output format is even
> > > slightly
> > > different from the SQL-mandated ISO format.
> > i understand, but that makes it very difficult to change the date format
> > afterwards. i simple flag to indicate no date conversion would be
> > helpfull....
>
> Well, these table_to_xml etc. functions are heavily constrained by the SQL
> standard, XML Schema, and others. They do what they are supposed to do. You
> are free to design your own XML export format or apply postprocessing to the
> existing ones (XSLT?). I don't think we should overload the existing
> functions with everyone's favorite but apparently completely nonstandard
> formatting variant flag.
it would be a flag to indicate no conversion from the datestyle settings
in the database...i think, from a users perspective, the table_to_xml is
completely useless, if you have to reformat everything afterwards....

jef
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>