Jef Peeraer wrote:
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
Just write a function that does your formatting afterwards.
2008/9/11 Jef Peeraer <[EMAIL PROTECTED]>:
>
>
> On Thu, 11 Sep 2008, Peter Eisentraut wrote:
>
>> Jef Peeraer wrote:
>> >
>> > On Thu, 11 Sep 2008, Peter Eisentraut wrote:
>> >
>> > > Tom Lane wrote:
>> > > > Jef Peeraer <[EMAIL PROTECTED]> writes:
>> > > > > i am using the xml add-ons, but the da
On Thu, 11 Sep 2008, Peter Eisentraut wrote:
> Jef Peeraer wrote:
> >
> > On Thu, 11 Sep 2008, Peter Eisentraut wrote:
> >
> > > Tom Lane wrote:
> > > > Jef Peeraer <[EMAIL PROTECTED]> writes:
> > > > > i am using the xml add-ons, but the date output format seems to be
> > > > > wrong :
> > >
Jef Peeraer wrote:
On Thu, 11 Sep 2008, Peter Eisentraut wrote:
Tom Lane wrote:
Jef Peeraer <[EMAIL PROTECTED]> 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
2008/9/11 Jef Peeraer <[EMAIL PROTECTED]>:
>
>
> On Thu, 11 Sep 2008, Peter Eisentraut wrote:
>
>> Tom Lane wrote:
>> > Jef Peeraer <[EMAIL PROTECTED]> writes:
>> > > i am using the xml add-ons, but the date output format seems to be wrong
>> > > :
>> >
>> > I think the conversion to xml intention
On Thu, 11 Sep 2008, Peter Eisentraut wrote:
> Tom Lane wrote:
> > Jef Peeraer <[EMAIL PROTECTED]> 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 require
Tom Lane wrote:
Jef Peeraer <[EMAIL PROTECTED]> 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 wh
Jef Peeraer <[EMAIL PROTECTED]> 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.
regards, tom lane
--
Sent via pgs
i am using the xml add-ons, but the date output format seems to be wrong :
i have
show datestyle;
DateStyle
---
SQL, DMY
select agenda_datum from dossiers where id = 61;
agenda_datum
--
29/07/2008
select table_to_xml('dossiers', false, false, '');
gives (knip )
62
