Re: Please help

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