| From: | Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | getting counts . .please help |
| Date: | 2006-10-03 15:37:27 |
| Message-ID: | 20061003153727.62694.qmail@web38104.mail.mud.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
dear group,
I have a table:
Table: gob
gid | goid | gon
|gonms
-----+------------+----------------------------------+
2146 | GO:0000005 | ribosomal chaperone activity |
MF
2147 | GO:0000006 | zinc uptake transporter activity |
MF
2148 | GO:0000007 | zinc ion transporter activity |
MF
Table comb2:
c2id | gid | seq_id
--------+-------+--------
171912 | 4867 | 41087
171913 | 6844 | 54392
171914 | 3334 | 50007
171915 | 15562 | 38416
seq_id | seq_refseq | seq_gname
--------+--------------+-----------------
33014 | NM_025196 | GRPEL1
33015 | NM_007186 | CEP2
33016 | NM_018148 | LINS1
33017 | NM_199166 | ALAS1
33018 | NM_001029946 | C1orf178
seq_id and gid are in bridge table com2.
My question is :
I want to take each entry from table gobe (gid) and
count to how many seq_id is connected.
could any one help me please.
Thanks
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brendon Gleeson | 2006-10-04 07:03:50 | Testing / debuging data import |
| Previous Message | Eberhard Lisse | 2006-10-03 05:04:35 | Re: Potentially annoying question about date ranges (part 2) |