The following bug has been logged online:
Bug reference: 2908
Logged by: David Lloyd
Email address: lloy0076@adam.com.au
PostgreSQL version: 8.1
Operating system: Solaris 10
Description: ISO8601 Date / Time Format Incompatibility
Details:
According to the ISO standard, 8601:
--
Fractions may also be used with any of the three time elements. These are
indicated by using the decimal point (either a comma (which is preferred) or
dot).
--
http://en.wikipedia.org/wiki/ISO_8601
[Follow the links to one of the PDF standards from there]
However, inserting such a value gives an error:
lloy0076=# create table tstest(t timestamp);
CREATE TABLE
lloy0076=# insert into tstest values('2006-01-01 10:00:00,5');
ERROR: invalid input syntax for type timestamp: "2006-01-01 10:00:00,5"
lloy0076=# in
Notice the "invalid" input syntax.
Thanks,
DSL