Selecting from float4[] arrays - Mailing list pgsql-sql

Anyone know how I could select something from a table for all cases
where one or more value in an array of floats for that table equals a
specified value.

example,

    select * from table_name where table_name.float_array = 2.5;

where float_array is defined as an array of floats (float4[]).

I know the line I used in the example won't work because '=' doesn't
work on arrays.

Thanks.
-Tony


--

                        ( @@ )
 ////////////////////oOO*(__)*OOo///////////////////////
//                                                    //
// G. Anthony Reina, MD                               //
// The Neurosciences Institute                        //
// 10640 John Jay Hopkins Drive                       //
// San Diego, CA   92121  USA                         //
//                                                    //
// Voice: (619) 626-2000     FAX: (619) 626-2199      //
// E-mail: reina@nsi.edu                              //
//                                                    //
///////////////////////////////////////////////////////