Re: How to manage search results? - Mailing list pgsql-php

From Marius Andreiana
Subject Re: How to manage search results?
Date
Msg-id 1007980445.8519.0.camel@aurora.wdg.ro
Whole thread Raw
In response to Re: How to manage search results?  (Andrew McMillan <andrew@catalyst.net.nz>)
Responses Re: How to manage search results?  (Andrew McMillan <andrew@catalyst.net.nz>)
List pgsql-php
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/


pgsql-php by date:

Previous
From: Andrew McMillan
Date:
Subject: Re: How to manage search results?
Next
From: Laurent Patureau
Date:
Subject: pb when we change pg_log directory