Skip site navigation (1) Skip section navigation (2)

Entering '<1' and 'BDL'

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 (view raw or flat)
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

Responses

pdxpug by date

Next:From: Rich ShepardDate: 2010-04-20 02:09:08
Subject: Re: Entering '<1' and 'BDL' -- RESOLVED
Previous:From: gabrielleDate: 2010-04-16 21:35:32
Subject: "pause" the pg service in windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group