Thread: Problem with TIME datatype

Problem with TIME datatype

From
"shura"
Date:
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.

Re: Problem with TIME datatype

From
Tom Lane
Date:
"shura" <shura@crlab.com> writes:
> I get following output for time_f field
> 00:00:00

> I use PostgreSQL 7.3

Please update to 7.3.2 --- there were some relevant bug fixes.

            regards, tom lane