Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id C00819F9C35 for ; Sun, 10 Dec 2006 23:33:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 47285-08 for ; Sun, 10 Dec 2006 23:33:25 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.231]) by postgresql.org (Postfix) with ESMTP id 7E9439F9386 for ; Sun, 10 Dec 2006 23:33:25 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id i28so1578638wxd for ; Sun, 10 Dec 2006 19:33:24 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=NdhoQ93OICBoTNiFvpM0bLHzMiEsUjh/QMg8Lv96PL3KbEeCn0eT9v9ORlvtpZGVRodDQSYBAbPiQQ2Q4THHBtCcoOFT7atYmT2AiQi5kz7w/BFb5RG7zRXmH69eiYt1MTFhj7DM4LTT76bcWa6qE2FaqjguURnvJDvWu0lqDFg= Received: by 10.70.68.11 with SMTP id q11mr11391654wxa.1165808004029; Sun, 10 Dec 2006 19:33:24 -0800 (PST) Received: from ?10.1.1.11? ( [203.217.18.65]) by mx.google.com with ESMTP id g9sm11137300wra.2006.12.10.19.33.22; Sun, 10 Dec 2006 19:33:23 -0800 (PST) Message-ID: <457CD182.7020004@gmail.com> Date: Mon, 11 Dec 2006 14:33:22 +1100 From: Chris User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: marcosborges@mbsi.com.br CC: pgsql-performance@postgresql.org Subject: Re: SQL_CALC_FOUND_ROWS in POSTGRESQL / Some one can helpe References: <457814D3.1030001@mbsi.com.br> In-Reply-To: <457814D3.1030001@mbsi.com.br> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/200 X-Sequence-Number: 22256 Marcos Borges wrote: > 07/12/2006 04:31 > *SQL_CALC_FOUND_ROWS in POSTGRESQL* > > In mysqln i m using the command SQL_CALC_FOUND_ROWS in follow sintax. > SELECT SQL_CALC_FOUND_ROWS name, email, tel FROM mytable WHERE name <> > '' LIMIT 0, 10 > to have the recorset data. > and > SELECT FOUND_ROWS(); > to have the total of registers found. > > I dont want to use the command count(*), because the performance will > fall down, depending of the quantyt of tables and "joins". > > The Data base postgresql have something similar ??? Nope, you're out of luck sorry. That's a mysql-ism and I doubt postgres will ever include something similar. -- Postgresql & php tutorials http://www.designmagick.com/