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.