Hello
2011/1/1 Esmin Gracic <esmin.gracic@gmail.com>:
> 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');
>
xsd define format for date, so you have to use a to_char function or
just cast to text.
Regards
Pavel Stehule
> 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ć
>