"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: yyyy-mm-dd hh24:mi:ss
> XSD: yyyy-mm-ddThh24:mi:ss

Why is that a good idea?  Even if some standard out there mandates the
'T', I'd bet lunch that the other format is a whole lot more portable.

if you use xsd schema then situation is clear. I have to respect it, because xsd:datetime is well defined and SQL/XML expect respecting xsd. If I don't use xsd schema, then I teoreticly can put date in any format. Sample: we use german format, but everybody with good mind doesn't use it for xml, because then he cannot use xml validation based on xsd schema.

xsd format use Oracle 10g: http://forums.oracle.com/forums/thread.jspa?threadID=467278&tstart=0
9x used ISO format, which is (however) invalid.


Currently without this patch PostgreSQL generate invalalid xml documents. That is all.

My patch doesn't protect any output. Simply use cast to text, or to_char fce.

nice a day
Pavel Stehule

Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com. http://www.msn.cz/

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to