Received: from corporate.fx.ro (corporate.fx.ro [193.231.208.29]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBAARwm99852 for ; Mon, 10 Dec 2001 05:27:58 -0500 (EST) (envelope-from marius@wdg.ro) Received: from fx.ro (Beavis.fx.ro [193.231.208.21]) by corporate.fx.ro (8.10.1/8.10.1) with ESMTP id fBAAPLl15187 for ; Mon, 10 Dec 2001 12:25:21 +0200 Received: from amber.wdg.ro ([193.231.212.69]) by fx.ro (8.10.1/8.10.1) with ESMTP id fBAAPHn12849 for ; Mon, 10 Dec 2001 12:25:17 +0200 (EET) Received: from aurora.wdg.ro (IDENT:marius@aurora.wdg.ro [192.168.1.8]) by amber.wdg.ro (8.9.3/8.9.3) with ESMTP id MAA27853; Mon, 10 Dec 2001 12:23:43 +0200 Subject: Re: How to manage search results? From: Marius Andreiana To: Andrew McMillan Cc: pgsql-php In-Reply-To: <1007978396.2311.6.camel@kant.mcmillan.net.nz> References: <1007976478.8206.2.camel@aurora.wdg.ro> <1007978396.2311.6.camel@kant.mcmillan.net.nz> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/0.99.0 (Preview Release) Date: 10 Dec 2001 12:32:35 +0200 Message-Id: <1007980445.8519.0.camel@aurora.wdg.ro> Mime-Version: 1.0 X-Archive-Number: 200112/6 X-Sequence-Number: 781 On Lu, 2001-12-10 at 11:59, Andrew McMillan wrote: > I just construct my query in the normal way and append a LIMIT ... > OFFSET ... clause to control the finally select records. I can't do that. Some of the queries I use are complex; after you run a query you can refine it, add to results, substract from results... I use a table to build the results from initial query, then add/remove to it as needed until search is done and finally user starts to browse the results. I can't make it in one huge query. For simple queries your solution is the best, no need for a table; I assume you just save the query in a session variable. I also assume your query doesn't take more than a second to run. thanks -- Marius Andreiana -- You don't have to go to jail for helping your neighbour http://www.gnu.org/philosophy/