On 12/17/2012 05:30 PM, Kirk Wythers wrote:
Thanks.
Is there a way to use the float4 data type for a variable when empty
records contain "NA", instead of nothing? As you can see below the
variable "A_TC_AVG1" has the first record filled with "NA" signifying
that the record is empty? Records that contain values will have decimal
values like 12.3456.
Either preprocess the data to turn NA into NULL or put the data into a
staging table that is looser about types (i.e. use varchar for this
column) and then transform in place and then move over into the final table.
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
