From: | "G(dot) Anthony Reina" <reina(at)nsi(dot)edu> |
---|---|
To: | reina(at)nsi(dot)edu, "pgsql-questions(at)postgresql(dot)org" <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | Selecting from float4[] arrays |
Date: | 1998-09-22 20:09:55 |
Message-ID: | 36080413.5DA79691@nsi.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)nsi(dot)edu //
// //
///////////////////////////////////////////////////////
From | Date | Subject | |
---|---|---|---|
Next Message | William Leeke | 1998-09-22 20:30:29 | create function syntax question |
Previous Message | Patrick Giagnocavo | 1998-09-22 19:53:31 | case-insensitive SORT BY? |