On 24 May 2012 05:30, Peter Eisentraut <peter_e@gmx.net> wrote:
> On mån, 2012-05-21 at 15:34 +1000, Brendan Jurd wrote:
>> I'd be okay with just adding a note in the manual under Date/Time
>> Output to the effect of "Note: ISO 8601 specifies the use of uppercase
>> letter 'T' to separate the date and time. Postgres uses a space for
>> improved readability, in line with other database systems and RFC
>> 3339."
>
> But that is wrong. We use the space because SQL says so. The reason we
> have all those other formats is for readability or consistency or some
> secondary standard. But the format of the ISO format is exactly what
> the SQL standard says, without any other considerations.
>
Did you miss my follow-on message on this thread? You are responding
to a message that has been superceded. I saw what you wrote earlier,
and updated my suggestions for the docs 2 days ago.
Please see
http://archives.postgresql.org/message-id/CADxJZo34mA54iMgd7RUADCC-R6LQ7w-TA8gqWvahKuA7BSV8vg@mail.gmail.com
Cheers,
BJ