Re: Please help

Hi Sean,
I tried a SELECT statement in INSERT Statement.



INSERT into xx(aa,aa,my_FK) values(bb,bb,

(SELECT my_fk
from my_chip_table
where chip_description ~'U133A'
)
);

The problem with this procedure is:

 genechip_id
-------------
           4
           5
(2 rows)


I am getting two chips:

4 | Human Genome U133A 2.0 Array |Homo sapiens
5 | Human Genome U133A Array  | Homo sapiens

U133A has also a Ver.2.

Any suggestions?

Thanks
Kumar




--- Sean Davis <sdavis2@mail.nih.gov> wrote:

>
> On Mar 1, 2005, at 12:32 PM, Kumar S wrote:
>
> > Hello all,
> >
> >
> > I have a table and it has is like this:
> > exp_id
> >  exp_name
> >  exp_type
> >  exp_desc
> >  exp_pmid
> >  exp_paper
> >  exp_author
> >  genechip_id
> >  exp_rawdata_link
> >  con_id
> > Indexes:
> >     "experiment_pkey" primary key, btree (exp_id)
> > Foreign-key constraints:
> >     "$1" FOREIGN KEY (genechip_id) REFERENCES
> > genechip_array(genechip_id)
> >     "$2" FOREIGN KEY (con_id) REFERENCES
> > contacts(con_id)
> >
> >
> > Based on the data I have information that should
> fill
> > in this column U133A.
> >
> > What I have in the genechip_array table is
> >
> >  genechip_id |        fc_genechip_array  |gc_spec
> > --+----------------------+------------------
> >
> > 5 | Human Genome U133A Array   | Homo sapiens
> >
> >
> > Now how can I bring in the foreign key 5 to my
> > previous table. All I have is U133A.
> >
> > Could any one help me in this.
> >
>
> Postgresql doesn't do this automatically.  A foreign
> key only functions
> as a link between tables after it is formed.  You
> must supply the link
> in the first place by a lookup in the foreign table
> either in the
> client or as part of a function to load the data.
> You aren't going to
> have many genechip_ids, so you could easily just
> append a column full
> of "5" to the incoming data for each of those tables
> if you want a
> quick and easy solution.
>
> Sean
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>




__________________________________
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250