From: Edward W. Rouse <erouse@comsquared.com>
To: pgsql-sql@postgresql.org
Subject: Re: it's not NULL, then what is it?
Date: Tue, 30 Jun 2009 18:22:12 -0400
Message-ID: <0ab801c9f9d1$376ad880$a6408980$@com> (raw)
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C04E84C01@egcrc-ex01.egcrc.org>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C04E84C01@egcrc-ex01.egcrc.org>
Just out of curiosity did you try maf = 0?
Edward W. Rouse
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
On Behalf Of Tena Sakai
Sent: Tuesday, June 30, 2009 6:03 PM
To: pgsql-sql@postgresql.org
Subject: [SQL] it's not NULL, then what is it?
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
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: erouse@comsquared.com
Subject: Re: it's not NULL, then what is it?
In-Reply-To: <0ab801c9f9d1$376ad880$a6408980$@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