Skip site navigation (1) Skip section navigation (2)

Re: Non-Unique intems

From: Srinivas Iyyer <srini_iyyer_bio(at)yahoo(dot)com>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Non-Unique intems
Date: 2006-03-28 22:12:02
Message-ID: 20060328221202.62952.qmail@web38113.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi Sean and group, 
 thank you for your help. It worked. 
However, I guess I stepped on a land mine of unique 
and non-unique items.  

Here is the problem:
(Example data) I have table A:

seq_id   seq_name
123        ITAM3
234        ITAR


Table B:

spot_id  seq_id   image_name
--------------------------------------------
849343    123       IMAGE: 12335
1348238   234       IMAGE: 12335




Table C:

exp_id |  spot_id  | spot_value
-------|-----------|-----------

Data to insert into Table C 
IMAGE: 12335   98.03344






Here the log of query:

arraydb=# SELECT spotanno_id from spotanno
arraydb-# where spotanno_imageid = 'IMAGE:755402';
 spotanno_id
-------------
      849343
     1348238
(2 rows)

arraydb=# select * from spotanno where spotanno_id =
849343;
 spotanno_id | seq_id | spotanno_imageid
-------------+--------+------------------
      849343 |  75343 | IMAGE:755402
(1 row)

arraydb=# select * from spotanno where spotanno_id =
1348238;
 spotanno_id | seq_id | spotanno_imageid
-------------+--------+------------------
     1348238 |  50475 | IMAGE:755402
(1 row)

arraydb=# select * from seqdump where seq_id = 50475;
 seq_id |  seq_acc  | seq_name
--------+-----------+----------
  50475 | NM_005501 | ITGA3
(1 row)

arraydb=# select * from seqdump where seq_id = 75343;
 seq_id |  seq_acc  | seq_name
--------+-----------+----------
  75343 | NM_002204 | ITGA3
(1 row)


An instance of row of the data file that to be
uploaded:


IMAGE:755402    0.299781845119261     
12.3638881597060



The question: 
when I have a non-unique item (viz. IMAGE:755402 )
what is the approach one should generally take. 

Do you have any suggestions/solution. Please help me. 

Thanks again. 

-sri

> 
> That should do it, approximately.  If you still have
> problems, then you 
> will need to be more specific about what the
> problems are, I think.
> 
> As an aside, I have similar data stored in a
> postgres database, but in 
> some places on the order of several 10's of millions
> of records; 
> postgres is not limiting in this respect.
> 
> Sean
> 

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

In response to

Responses

pgsql-novice by date

Next:From: Michael Talbot-WilsonDate: 2006-03-29 00:21:44
Subject: Re: plpgsql questions
Previous:From: Michael SwierczekDate: 2006-03-28 16:52:47
Subject: Re: plpgsql questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group