On Mar 1, 2005, at 1:03 PM, Kumar S wrote:
> 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.
>
So which one do you want? If you know you want only #5, then you can
just do
~ 'U133A Array'
for hgu133A or
~ 'U133A 2'
for AV2.
If you want to lump all 133A arrays together, regardless of version, I
would suggest changing the my_chip_table to have only one U133 entry to
stave off future confusion.
Sean
