Postgres Pro
Downloads
Home   >   mailing lists

Re: Timestamp and interval precision - Mailing list pgsql-general

From Tom Lane
Subject Re: Timestamp and interval precision
Date
Msg-id 129.1067273229@sss.pgh.pa.us
Whole thread Raw
In response to Timestamp and interval precision  ("Vilson farias" <vilson.farias@digitro.com.br>)
List pgsql-general
Tree view 
"Vilson farias" <vilson.farias@digitro.com.br> writes:
> bxs=# select CAST('10:32:14.553243' AS interval(0));
>     interval
> -----------------
>  10:32:14.553243
> (1 row)

This is a known bug in 7.3 and before --- it's fixed for 7.4.

            regards, tom lane

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Recomended FS
Next
From: Bruce Momjian
Date:
Subject: Re: Question about the Internals