complex queries - Mailing list pgsql-novice

Hi Sean and group members,

with all your help i could upload a part of my dataset
successfully into my database.

I am queying my database. currently I am querying two
tables for data.

There are two tables processed_data and
sequence_annotation.


My first query (which is successful):

db=> select proc_exprs, proc_pval from processed_data,
sequence_annotation
where processed_data.seq_anno_id =
sequence_annotation.seq_anno_id
and sequence_annotation.seq_gene_symbol = 'FN1';
 proc_exprs | proc_pval
------------+-----------
    6.72867 |  0.141216
    5.01667 |  0.212055
    4.94133 |  0.216501
   0.214667 |  0.624944
  0.0846667 |  0.525513
    7.19867 |  0.128558
    11.7807 |  0.053066
    11.5487 | 0.0545418
    7.57867 | 0.0984488
       0.33 |  0.678788
  0.0546667 |  0.483358
    11.7227 | 0.0534283
      4.806 |  0.221026
    2.86333 |  0.434024
    3.60933 |  0.324803
       0.43 |  0.742388
      0.018 |  0.427739
      3.222 |  0.375615
(18 rows)


Query 2: A little complicated one (successful):

db=> select proc_exprs, proc_pval, seq_anno_id from
processed_data
 where proc_pval < 0.004;
 proc_exprs | proc_pval  | seq_anno_id
------------+------------+-------------
    107.803 | 0.00382485 |       50237
    106.607 | 0.00387695 |       51903
    158.191 | 0.00240939 |       69829
    170.103 | 0.00220903 |       70008
    137.591 | 0.00284852 |       70009
    217.086 | 0.00165253 |       70214
    186.021 | 0.00198545 |       70223
    213.575 | 0.00168479 |       70558
    121.545 | 0.00330776 |       71717
    221.715 | 0.00161171 |       71757
    248.226 |  0.0014101 |       75187
    111.929 | 0.00365456 |       80492
      138.5 |  0.0022871 |       70008
    90.9887 | 0.00380519 |       70009

Query 3: A complicated one( unsuccessful):

bob=> select proc_exprs, proc_pval, seq_gene_symbol
from processed_data, sequence_annotation
where proc_pval < 0.05 AND
processed_data.seq_anno_id =
sequence_annotation.seq_gene_symbol;


 proc_exprs | proc_pval | seq_gene_symbol
------------+-----------+-----------------
(0 rows)


seq_gene_symbol is in sequence_annotation table and
its primary key is value of seq_anno_id.


Why I am getting 0 row. Whats wrong with my query.

Could you help me please.

Thank you.

K


My tables:
Processed_data table:
   Column    |          Type          |
              Modifiers
-------------+------------------------+---------------------------------------------------------------------
 proc_id     | integer                | not null
default
nextval('public.processed_data_proc_id_seq'::text)
 exp_id      | integer                |
 seq_anno_id | integer                |
 cel_id      | integer                |
 proc_symbol | character varying(100) |
 proc_exprs  | real                   |
 proc_pval   | real                   |
Indexes:
    "processed_data_pkey" primary key, btree (proc_id)
Foreign-key constraints:
    "$2" FOREIGN KEY (exp_id) REFERENCES
experiment(exp_id)
    "$3" FOREIGN KEY (seq_anno_id) REFERENCES
sequence_annotation(seq_anno_id)
    "$4" FOREIGN KEY (cel_id) REFERENCES cel(cel_id)



Sequence_annotation table:
       Column         |           Type           |
                             Modifiers

-----------------------+--------------------------+------------------------------------------------------------------------------
 seq_anno_id           | integer                  |
not null default
nextval('public.sequence_annotation_seq_anno_id_seq'::text)
 seq_probeset_id       | character varying(15000) |
 seq_source            | character varying(15000) |
 seq_transcript_id     | character varying(15000) |
 seq_target_desc       | character varying(15000) |
 seq_rep_pub_id        | character varying(15000) |
 seq_unigene_id        | character varying(15000) |
 seq_alignment         | character varying(15000) |
 seq_gene_title        | character varying(15000) |
 seq_gene_symbol       | character varying(15000) |
 seq_chr_location      | character varying(15000) |
 seq_ensembl           | character varying(15000) |
 seq_locus_link        | character varying(15000) |
 seq_swissport         | character varying(15000) |
 seq_ec                | character varying(15000) |
 seq_omim              | character varying(15000) |
 seq_refseq_prot_id    | character varying(15000) |
 seq_refseq_trans_id   | character varying(15000) |
 seq_flybase           | character varying(15000) |
 seq_agi               | character varying(15000) |
 seq_wormbase          | character varying(15000) |
 seq_mgi_name          | character varying(15000) |
 seq_rgd_name          | character varying(15000) |
 seq_sgd_acc           | character varying(15000) |
 seq_go_bp             | character varying(15000) |
 seq_go_cc             | character varying(15000) |
 seq_go_mf             | character varying(15000) |
 seq_pathway           | character varying(15000) |
 seq_prot_family       | character varying(15000) |
 seq_prot_domain       | character varying(15000) |
 seq_interpro_id       | character varying(15000) |
 seq_tm                | character varying(15000) |
 seq_qtl               | character varying(15000) |
 seq_ann_trasc_cluster | character varying(15000) |
 seq_transc_assign     | character varying(15000) |
 seq_anno_notes        | character varying(15000) |
 genechip_id           | integer                  |
Indexes:
    "sequence_annotation_pkey" primary key, btree
(seq_anno_id)
Foreign-key constraints:
    "$1" FOREIGN KEY (genechip_id) REFERENCES
genechip(genechip_id)



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com