From: Tom Lane <tgl@sss.pgh.pa.us>
To: Matthew Hagerty <matthew@venux.net>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Methods for stepping through results?
Date: Tue, 16 Feb 1999 10:47:21 -0500
Message-ID: <27457.919180041@sss.pgh.pa.us> (raw)
In-Reply-To: <4.1.19990215221328.0097ae10@mail.venux.net>
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 ...
There has been some talk of providing a facility for this inside libpq,
where it could be used for handling the results of an ordinary SELECT.
But it doesn't seem real high priority, given that you can use a cursor.
> 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?
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, matthew@venux.net
Subject: Re: [INTERFACES] Methods for stepping through results?
In-Reply-To: <27457.919180041@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox