As it turns out, evidence would suggests that the "ISO" output in
Postgres isn't, unless there's an ISO standard for date and time that
is referring to other than 8601. It does not permit use of a space
between the date and the time, as seen in:
SELECT now();
now
-------------------------------
2012-02-23 23:31:59.580915-08
(1 row)
Thanks to Vasily Chekalkin for digging that up. He was annoyed at the
time, so someone actually cares now and again, sample size one.
It is true that many common adaptations of ISO8601 do allow the space,
and many pages on the web that abstract the standard include that
variant, but it is not the letter of the standard, as far as I can
tell. It is an acceptable letter of the standard in RFC3339. Unless
one actually digs down in the ISO document -- this is the third
edition(!) -- one may be misinformed. Or perhaps it's buried in the
standard's PDF.
Here's a link to the standard:
http://dotat.at/tmp/ISO_8601-2004_E.pdf
I'm not sure if there's anything to be done here other than a mention
of errata in the manual. Alternatively, datestyle = 'sql' and
datestyle = 'iso' may be reasonably different, after all.
--
fdr
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
