The following bug has been logged online: Bug reference: 2908 Logged by: David Lloyd Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
