On Tuesday, February 16, 1999 9:47 AM, Tom Lane [SMTP:tgl@sss.pgh.pa.us] wrote:
> Matthew Hagerty <matthew@venux.net> writes:
> > Is there any way to do the following:
> > 1. Return a query in groups of x (i.e. 10 or 20) and progressively return
> > result groups of x. Just think of search engine navigation.
>
> DECLARE CURSOR ... FETCH ...
>
>
> > 2. I have a client who wants to be able to select certain rows (tuples) of
> > a result and then "re-submit" the query and have only those rows selected
> > in the new results. For example, if a query returns 10 rows and rows
> > 2,4,7,9 are checked, when re-submitted only rows 2,4,7,9 would be returned.
> > I know it is kind of stupid, but I have to please the customer :(
>
> Seems like something you should be handling inside your application.
> Why would you "re-submit" the same query in the first place, if you
> already have the results?
>
I don't think he wants to resubmit the same query, what he wants is to perform
a secondary query on the results of the first.
Probably what you should do is create a temporary table with the results of the first
query "SELECT INTO ...."
Use the DECLARE CURSOR to scroll through the results of the 1st query.
Then for the 2nd query, perform the query on the temporary table.
If you realy do want to do it as stated above where the re-submitted query only
returns the selected items from the first query, then why don't you display the
results of the first query in a list, and delete the unwanted items instead of performing
a 2nd query ?
