Thread: Copying to float8 data type

Copying to float8 data type

From

"William Herring"

Date:

19 February 2002, 18:53:24

I am attempting to copy records to a table with a column defined as float8. However, it will only accept values not equal to 0. Several of the values are indeed 0. Any suggestions?

Re: Copying to float8 data type

From

Bruce Momjian

Date:

19 February 2002, 19:24:13

William Herring wrote:
> I am attempting to copy records to a table with a column defined as float8.
> However, it will only accept values not equal to 0.  Several of the values
> are indeed 0.  Any suggestions?

This sound very bizarre.  Please show a reproducable case.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026