query_to_xml function ignores Datestyle?

From: Esmin Gracic <esmin(dot)gracic(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: query_to_xml function ignores Datestyle?
Date: 2011-01-01 17:23:27
Message-ID: AANLkTinV4u4j87xotf67yJGCJiu-OFc-pCS7CNJxUr=j@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It seems that query_to_xml function ignores Datestyle settings?
Is this correct? If yes, is there any workarounf except
to_char(date,'dd.mm.yyyy');

set datestyle = 'German';
select current_date;
select QUERY_TO_XML('select current_date',true,false,'');

Postgresql 9.0 on Ubuntu 10.04 Server (64-bit)

Esmin Gracić

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2011-01-01 18:01:44 Re: query_to_xml function ignores Datestyle?
Previous Message tuanhoanganh 2011-01-01 10:27:17 Re: Stream Replication archive command Access is denied question