On Mon, Dec 12, 2005 at 13:04:05 -0500,
Jim Buttafuoco <[EMAIL PROTECTED]> wrote:
>
> try
>
>
> select '2005-12-01'::date + (456.5::float || ' seconds')::interval;
> ?column?
> ------------------------
> 2005-12-01 00:07:36.50
> (1 row)
You are better off doing a multiply. Something like:
area=> select '2005-12-01'::date + 456.5 * '1 second'::interval;
?column?
------------------------
2005-12-01 00:07:36.50
(1 row)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
