On 12/17/2012 05:46 PM, Adrian Klaver wrote:
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.
Although it may be overkill for a simple case like this, especially if
it is a one-time load, there are plenty of open-source ETL tools out
there: https://www.google.com/search?q=open+source+etl
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
