Received: from nsi.edu (amethea.nsi.edu [198.133.185.9]) by hub.org (8.8.8/8.8.8) with ESMTP id QAA27279 for ; Tue, 22 Sep 1998 16:08:26 -0400 (EDT) (envelope-from reina@nsi.edu) Received: from nsi.edu (IDENT:reina@bigred.nsi.edu [204.128.156.214]) by nsi.edu (8.9.1/8.9.1) with ESMTP id NAA12856; Tue, 22 Sep 1998 13:08:20 -0700 (PDT) Sender: reina@nsi.edu Message-ID: <36080413.5DA79691@nsi.edu> Date: Tue, 22 Sep 1998 13:09:55 -0700 From: "G. Anthony Reina" Organization: The Neurosciences Institute X-Mailer: Mozilla 4.05 [en] (X11; I; Linux 2.0.34 i686) MIME-Version: 1.0 To: reina@nsi.edu, "pgsql-questions@postgresql.org" Subject: Selecting from float4[] arrays Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 // // // ///////////////////////////////////////////////////////