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
