Обсуждение: Copying to float8 data type

Поиск
Список
Период
Сортировка

Copying to float8 data type

От
"William Herring"
Дата:

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

От
Bruce Momjian
Дата:
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