From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
Cc: | Kirk Wythers <kirk(dot)wythers(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: data type - import problem |
Date: | 2012-12-18 17:53:10 |
Message-ID: | 50D0AD86.9000508@pinpointresearch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Rhys A.D. Stewart | 2012-12-18 19:31:42 | can one speed up a custom aggregate by using native ones |
Previous Message | Groshev Andrey | 2012-12-18 17:34:53 | Re: [GENERAL] trouble with pg_upgrade 9.0 -> 9.1 |