Re: Timestamp and interval precision

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org, "SIMONE Carla MOSENA" <simone(dot)mosena(at)digitro(dot)com(dot)br>
Subject: Re: Timestamp and interval precision
Date: 2003-10-27 16:47:09
Message-ID: 129.1067273229@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-10-27 16:59:16 Re: Question about the Internals
Previous Message Christoph Haller 2003-10-27 16:39:36 Re: extend INSERT by 'INSERT INTO table FETCH ... FROM cursor' syntax