Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id EDF1E9F9E92 for ; Thu, 4 Oct 2007 06:54:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 41105-06 for ; Thu, 4 Oct 2007 06:54:11 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 3950F9F9D22 for ; Thu, 4 Oct 2007 06:54:15 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.1/8.14.1) with ESMTP id l949sApi056113 for ; Thu, 4 Oct 2007 06:54:11 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.1/8.14.1/Submit) id l949Q5K0003745 for pgsql-admin@postgresql.org; Thu, 4 Oct 2007 06:26:05 -0300 (ADT) (envelope-from news) From: yogesh X-Newsgroups: pgsql.admin Subject: Postgres Array Traversing Problem Date: Thu, 04 Oct 2007 09:26:07 -0000 Organization: http://groups.google.com Lines: 26 Message-ID: <1191489967.494550.265430@y42g2000hsy.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.2; en-US; rv:1.8.1.7) Gecko/20070914 Firefox/2.0.0.7,gzip(gfe),gzip(gfe) X-HTTP-Via: 1.1 SUMAN1, 1.1 SIFY Complaints-To: groups-abuse@google.com Injection-Info: y42g2000hsy.googlegroups.com; posting-host=124.30.27.18; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/21 X-Sequence-Number: 26935 Hello Friends, I have a Problem in Accessing Arrays in the Postgres. The Description of my problem is given here:----------------------- I have two array of numeric types. One That stores the IDs and Other Store their values at respective position. One Id could be in more than one Row's Array. Now i have to search the ID if it is present in the Array or not. If present then at what position and to retrieve the corresponding ID and its Value....present in the other table...... Is there any solution of it................If any Body knows please reply me as soon as possible....... any kind of help is appreciated If you have any problem in understanding problem then mail me.... My EMail Ids are yogesh.arora.daffodil@gmail.com and yogesh.arora@daffodildb.com I am in wait of your responses............ Thanks in advance..............