Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7BDFB9FC03E for ; Wed, 30 May 2007 16:11:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 13420-07 for ; Wed, 30 May 2007 16:11:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web52712.mail.re2.yahoo.com (web52712.mail.re2.yahoo.com [206.190.48.235]) by postgresql.org (Postfix) with SMTP id 7533A9FC01C for ; Wed, 30 May 2007 16:11:38 -0300 (ADT) Received: (qmail 24952 invoked by uid 60001); 30 May 2007 19:11:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=vA/akcbOnQfo2pbOtbmXMPM+7Xj4gFt852M7EiyiaZztTKoD8HvgaUd8tJlM1X+oRxYntWyIsJcyvqX0A+v9TE75oQH4taw3n33b5zyL+VDqmqyeVRUlZjASTU5zBTN96HVPy4VqbDBNjOBGyiMPb7/FUwkMHSDjX9MXlu403eM=; X-YMail-OSG: GLZsKyQVM1lupmAbj._2rWiS4kFUwGY9NgKezEY1ZPdYgWn6_4Kp43qa559LHB1JExaml6pNmPR4xxFGkkNsCk5nLDaAqV7buSh.gfH0T0NHIsSiCX5NyVrrPpLMyyEF1E1NqxFKz8dVNhPrcO_x9QrVZw-- Received: from [195.168.227.227] by web52712.mail.re2.yahoo.com via HTTP; Wed, 30 May 2007 12:11:37 PDT X-Mailer: YahooMailRC/651.23.1 YahooMailWebService/0.7.41.14 Date: Wed, 30 May 2007 12:11:37 -0700 (PDT) From: Trigve Siver Subject: Re: slow query execution To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=ascii Message-ID: <383089.24941.qm@web52712.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.062 tagged_above=0 required=5 tests=AWL=-0.108, BAYES_40=-0.185, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447 X-Spam-Level: *** X-Archive-Number: 200705/202 X-Sequence-Number: 28482 >----- Original Message ---- >From: Richard Huxton >To: Trigve Siver >Cc: pgsql-sql@postgresql.org >Sent: Wednesday, May 30, 2007 9:05:09 PM >Subject: Re: [SQL] slow query execution > >Trigve Siver wrote: >> >> I seee...when new data will be added to table, then row numbers wouldn''t be valid anymore. >> >> Hmmm...looked like I need to find other solution. > >Try explaining what it is you're trying to achieve, and maybe someone >will be able to suggest a solution. I need to perform search on some query (which is already shown in Listview control) and highlight items that meet search criteria. thanks Trigve ____________________________________________________________________________________ Don't pick lemons. See all the new 2007 cars at Yahoo! Autos. http://autos.yahoo.com/new_cars.html