Selecting from float4[] arrays

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 //
// //
///////////////////////////////////////////////////////

Browse pgsql-sql by date

  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?