| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Brendan Jurd <direvus(at)gmail(dot)com> |
| Cc: | Daniel Farina <daniel(at)heroku(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: External Open Standards |
| Date: | 2012-05-23 19:30:34 |
| Message-ID: | 1337801434.23660.12.camel@vanquo.pezone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-05-23 19:33:32 | Re: Readme of Buffer Management seems to have wrong sentence |
| Previous Message | Peter Eisentraut | 2012-05-23 19:23:50 | Re: Changing the concept of a DATABASE |