Re: Copying to float8 data type - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Copying to float8 data type
Date
Msg-id 200202192058.g1JKwKj23728@candle.pha.pa.us
Whole thread Raw
In response to Copying to float8 data type  ("William Herring" <wherring@mail.ifas.ufl.edu>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Alternate database locations
Next
From: Bruce Momjian
Date:
Subject: Re: Performance impact of NULLs and variable length fields