Problem with TIME datatype - Mailing list pgsql-bugs

From shura
Subject Problem with TIME datatype
Date
Msg-id 000701c2e2e2$8c1bbeb0$6800a8c0@shura
Whole thread Raw
Responses Re: Problem with TIME datatype
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: Neil Conway
Date:
Subject: Re: bug with vacuum analyze?
Next
From: Edoardo Panfili
Date:
Subject: reload of shared library