| From: | Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com> |
|---|---|
| To: | Postgresql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Question |
| Date: | 2006-02-06 15:54:49 |
| Message-ID: | 829d7fb60602060754o726d025fq657c222a7053d455@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi All,
I am trying to create a simpel table to handle geneId and productId but the
data file which i want to read in has for some genes more than one productId
ex:
GeneId | ProID1 /// ProID2 /// ProID3
Now how does one input the same information without having GeneId listed in
the table more than once if possible?!!!
If i read-in the info. just as it appears in the file then will the querying
be a big problem since there is more than one ProID/ per gene and not to
mention '///' characters!
Thanks in advance.
Hrishi
AFFX-HSAC07/X00351_3_st
AFFX-HSAC07/X00351_3_st
---
ENSG00000178309 /// ENSG00000178987 /// ENSG00000075624
AFFX-HSAC07/X00351_3_st
---
ENSG00000178309 /// ENSG00000178987 /// ENSG00000075624
AFFX-HSAC07/X00351_3_st
---
ENSG00000178309 /// ENSG00000178987 /// ENSG00000075624
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Leif Jensen | 2006-02-06 16:17:20 | ftp download won't work |
| Previous Message | Shahid Butt | 2006-02-06 15:33:47 | Trying to auto start Postgres when server boots up |