Re: Non-Unique intems

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