Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 6D9F763423D for ; Tue, 30 Jun 2009 19:32:48 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 03647-04 for ; Tue, 30 Jun 2009 19:32:46 -0300 (ADT) X-Greylist: delayed 00:10:25.295282 by SQLgrey-1.7.6 Received: from smtp.comsquared.com (smtp.comsquared.com [209.155.237.140]) by mail.postgresql.org (Postfix) with ESMTP id 0E090632BBF for ; Tue, 30 Jun 2009 19:32:46 -0300 (ADT) Received: from mdpserv.comsquared.com (mdpserv [10.82.40.1]) by smtp.comsquared.com (Switch-3.2.7/Switch-3.2.7) with ESMTP id n5UMMDkm012803 for ; Tue, 30 Jun 2009 18:22:18 -0400 (EDT) Received: from erouse052008 (erouse052008.ntc2s.comsquared.com [10.82.60.61]) by mdpserv.comsquared.com (8.13.6+Sun/8.13.6) with ESMTP id n5UMMCEM003849 for ; Tue, 30 Jun 2009 18:22:13 -0400 (EDT) From: "Edward W. Rouse" To: References: In-Reply-To: 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> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0AB9_01C9F9AF.B0593880" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Acn5zn9AixxL9PKuRYCgQ1BEOCyqSwAAqH3Q Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200906/129 X-Sequence-Number: 32734 This is a multipart message in MIME format. ------=_NextPart_000_0AB9_01C9F9AF.B0593880 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_0AB9_01C9F9AF.B0593880 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable it's not NULL, then what is it?

Just out of curiosity did you try maf =3D = 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=3D# \d gallo.sds_seq_reg_shw
       Table = "gallo.sds_seq_reg_shw"
        = Column      |  Type   | Modifiers
  ------------------+---------+-----------
   name           &nb= sp; | text    |
   response         | = text    |
   n            =     | integer |
   = source           | text    |
   test           &nb= sp; | text    |
   ref           &nbs= p;  | text    |
   value            = | real    |
   pvalue.term      | = real    |
   stars.term       | text    |
   gtclass.test     | = text    |
   fclass.test      | = text    |
   gtclass.ref      | = text    |
   fclass.ref       | text    |
   markerid         | = integer |
   maf           &nbs= p;  | real    |
   chromosome       | text    |
   physicalposition | integer |
   id            = ;   | text    |
   = ctrast           | text    |
 
I am intereseted in the column maf (which is real):

  canon=3D# 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=3D# select maf from gallo.sds_seq_reg_shw
  canon-#  order by maf desc;
       maf    
  -------------
            &= nbsp;
            &= nbsp;
            &= nbsp;
        .
  (trunacated for the interest of breivity)
        .

These rows shown are blanks, as far as I can tell.
But...

  canon=3D# select count(maf) from gallo.sds_seq_reg_shw;
   count
  -------
   67284
  (1 row)
 
  canon=3D# select count(maf) from gallo.sds_seq_reg_shw
  canon-#  where maf ISNULL;
   count
  -------
       0
  (1 row)
 
  canon=3D#
  canon=3D# 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

------=_NextPart_000_0AB9_01C9F9AF.B0593880--