| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | Kirk Wythers <kirk(dot)wythers(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: data type - import problem |
| Date: | 2012-12-18 01:46:20 |
| Message-ID: | 50CFCAEC.5020607@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2012-12-18 02:21:59 | Re: [GENERAL] trouble with pg_upgrade 9.0 -> 9.1 |
| Previous Message | Bruce Momjian | 2012-12-18 01:40:10 | Re: trouble with pg_upgrade 9.0 -> 9.1 |