| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pdxpug(at)postgresql(dot)org |
| Subject: | Entering '<1' and 'BDL' |
| Date: | 2010-04-19 23:12:06 |
| Message-ID: | alpine.LNX.2.00.1004191608060.22750@salmo.appl-ecosys.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pdxpug |
For a scientific database holding observed and measured values there are
two non-numeric (NAN) legitimate entries: <1 and 'below detection limits.'
Is anyone aware of a standard way of expressing these?
The problem is that the column needs to be of a numeric type because the
numbers will be manipulated mathematically and summarized statistically. So
a NAN such as '<1' or 'BDL' doesn't cut it.
Any thoughts?
Rich
--
Richard B. Shepard, Ph.D. | Integrity Credibility
Applied Ecosystem Services, Inc. | Innovation
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2010-04-20 02:09:08 | Re: Entering '<1' and 'BDL' -- RESOLVED |
| Previous Message | gabrielle | 2010-04-16 21:35:32 | "pause" the pg service in windows |