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

Re: Entering '<1' and 'BDL' -- RESOLVED

From: "Melissa Hollingsworth" <melissa(at)fastanimals(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: Entering '<1' and 'BDL' -- RESOLVED
Date: 2010-04-20 16:16:02
Message-ID: op.vbg0w0emoen9tq@satin.mshome.net (view raw or flat)
Thread:
Lists: pdxpug
On Mon, 19 Apr 2010 20:09:08 -0600, Rich Shepard  
<rshepard(at)appl-ecosys(dot)com> wrote:

> On Mon, 19 Apr 2010, Rich Shepard wrote:
>
>>  Any thoughts?
>
>    NULL does the trick. After all, if the value is below detection  
> limits or
> less than 1 the actual value is unknown.

Might you ever need to distinguish between something less than one
and something which was actually undetectably low?  I don't like
losing information, personally.

Using NULL for both loses the distinction between them. If you'll
never need to distinguish them, why are there two valid NAN values
in the first place?

-- 
Melissa Hollingsworth
melissa(at)fastanimals(dot)com
+1 503 841 5240

In response to

pdxpug by date

Next:From: Ewan, MichaelDate: 2010-04-20 17:38:10
Subject: Re: Entering '<1' and 'BDL'
Previous:From: Rich ShepardDate: 2010-04-20 02:09:08
Subject: Re: Entering '<1' and 'BDL' -- RESOLVED

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