From: Rob Sargent <robjsargent@gmail.com>
To: Tena Sakai <tsakai@gallo.ucsf.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: it's not NULL, then what is it?
Date: Tue, 30 Jun 2009 16:24:11 -0600
Message-ID: <4A4A908B.1080607@gmail.com> (raw)
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C04E84C01@egcrc-ex01.egcrc.org>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C04E84C01@egcrc-ex01.egcrc.org>
Tena Sakai wrote:
>
> Hi Everybody,
>
> I have a table called gallo.sds_seq_reg_shw,
> which is like:
>
> canon=# \d gallo.sds_seq_reg_shw
> Table "gallo.sds_seq_reg_shw"
> Column | Type | Modifiers
> ------------------+---------+-----------
> name | text |
> response | text |
> n | integer |
> source | text |
> test | text |
> ref | text |
> value | real |
> pvalue.term | real |
> stars.term | text |
> gtclass.test | text |
> fclass.test | text |
> gtclass.ref | text |
> fclass.ref | text |
> markerid | integer |
> maf | real |
> chromosome | text |
> physicalposition | integer |
> id | text |
> ctrast | text |
>
> I am intereseted in the column maf (which is real):
>
> canon=# select maf from gallo.sds_seq_reg_shw
> canon-# order by maf asc;
> maf
> -------------
> 0.000659631
> 0.000659631
> 0.000659631
> 0.000659631
> .
> (trunacated for the interest of breivity)
> .
>
> Another way to look at this column is:
>
> canon=# select maf from gallo.sds_seq_reg_shw
> canon-# order by maf desc;
> maf
> -------------
>
>
>
> .
> (trunacated for the interest of breivity)
> .
>
> These rows shown are blanks, as far as I can tell.
> But...
>
> canon=# select count(maf) from gallo.sds_seq_reg_shw;
> count
> -------
> 67284
> (1 row)
>
> canon=# select count(maf) from gallo.sds_seq_reg_shw
> canon-# where maf ISNULL;
> count
> -------
> 0
> (1 row)
>
> canon=#
> canon=# select count(maf) from gallo.sds_seq_reg_shw
> canon-# where maf NOTNULL;
> count
> -------
> 67284
> (1 row)
>
> My confusion is that if they are real and not null,
> what are they? How would I construct a query to do
> something like:
>
> select count(maf)
> from gallo.sds_seq_reg_shw
> where maf ISBLANK;
>
> Thank you in advance.
>
> Regards,
>
> Tena Sakai
> tsakai@gallo.ucsf.edu
>
Maybe something like
select ']' || maf::text || '[' -- just to see where the value
start/stops
or
select length(maf::text)
but I suspect you're getting NAN or something unprintable in your
environment?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: robjsargent@gmail.com, tsakai@gallo.ucsf.edu
Subject: Re: it's not NULL, then what is it?
In-Reply-To: <4A4A908B.1080607@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox