Hello, I create a table
CREATE TABLE test ( time_f TIME(7) ) Table was created succesffull INSERT INTO test VALUES ('16:28:45.1234567') Row was added When I try SELECT * FROM test I get following output for time_f field 00:00:00 Same result i has for all precisions greate than six, and for TIME WITH TIME ZONE data type I has the same effect. I use PostgreSQL 7.3 I try this on Cygwin 1.3-18 and on Linux RedHat 6.2 My building and runtime options has default values. Best regards, Alexander. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]