Received: from hotmail.com (f39.law3.hotmail.com [209.185.241.39]) by hub.org (8.10.1/8.10.1) with ESMTP id e857CZC10544 for ; Tue, 5 Sep 2000 03:12:35 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 5 Sep 2000 00:12:30 -0700 Received: from 164.164.86.66 by lw3fd.law3.hotmail.msn.com with HTTP; Tue, 05 Sep 2000 07:12:29 GMT X-Originating-IP: [164.164.86.66] From: "Umashankar Kotturu" To: pgsql-sql@hub.org Subject: Query on array-elements inside object Date: Tue, 05 Sep 2000 03:12:29 EDT Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 05 Sep 2000 07:12:30.0072 (UTC) FILETIME=[A751FF80:01C01708] X-Archive-Number: 200009/19 Hi, I am new to Postgres as well as object database. Wondering if one of you can tell me on how to write a sql query to select an object that has a particular element in an array. Example If I create an object-table with 2 elements. a) PatientID -> numeric b) DiseaseArray -> array of text - This DiseaseArray has elements like "cancer", "tb" etc... Now how will I write a sql-query to select all patients that have "cancer" Any pointers will be helpful. regards, Uma. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.