Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id DB9ED4760BB for ; Thu, 2 May 2002 08:19:24 -0400 (EDT) Received: from mail-relay.trade-india.com (unknown [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 3CA68475F7A for ; Thu, 2 May 2002 08:19:21 -0400 (EDT) Received: (qmail 9438 invoked from network); 2 May 2002 12:12:21 -0000 Received: from system29.trade-india-local.com (HELO server) (192.168.0.29) by ptil-236-129-del.primus-india.net with SMTP; 2 May 2002 12:12:21 -0000 Content-Type: text/plain; charset="iso-8859-1" From: "Rajesh Kumar Mallah." Organization: Infocom Network Limited. To: "Rajesh Kumar Mallah." Subject: Re: Weird select output... Date: Thu, 2 May 2002 05:36:49 -0400 X-Mailer: KMail [version 1.4] References: <200205020516.20495.mallah@trade-india.com> <200205020525.17826.mallah@trade-india.com> In-Reply-To: <200205020525.17826.mallah@trade-india.com> Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200205020536.49836.mallah@trade-india.com> X-Archive-Number: 200205/11 X-Sequence-Number: 7647 On Thursday 02 May 2002 05:25 am, you wrote: Hi Folks, the mentioned problem was solved on recreting the index on company_id. regds mallah. On Thursday 02 May 2002 05:16 am, Rajesh Kumar Mallah. wrote: > > Hi Folks, > > > > when does the below happen? > > > > tradein_clients=3D# SELECT company_id from branding_master where > > company_id=3D58498; > > > > company_id > > ------------ > > 58498 > > 42136 > > (2 rows) > > > > regards > > Mallah. --=20 Rajesh Kumar Mallah, Developer www.trade-india.com Infocom Network Limited, New Delhi. Internet: mallah@trade-india.com phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.