Question - Mailing list pgsql-general

From Hrishikesh Deshmukh
Subject Question
Date
Msg-id 829d7fb60602060754o726d025fq657c222a7053d455@mail.gmail.com
Whole thread Raw
Responses Re: Question  (Bruno Wolff III <bruno@wolff.to>)
List 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

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: change current user in pl/pgsql function
Next
From: Leif Jensen
Date:
Subject: ftp download won't work