From: Nicholas Allen <nallen@freenet.co.uk>
To: pgsql-sql@postgresql.org
Subject: How do you select from a table until a condition is met?
Date: Wed, 12 Feb 2003 19:10:38 +0100
Message-ID: <200302121910.38232.nallen@freenet.co.uk> (raw)
Hi,
I am hoping that someone can help me with a problem I have. I would like to be
able to perform a SELECT query to select values from a table upto a certain
row. The select may be ordered on a number of items. Is it possible to do
this and how should I do it?
The reason I need this is because I have created a virtual table browser class
that performs SQL queries to get the sections of the table the user is
interested in. This way I don't load the whole table onto the client side. If
the user changes the sort ordering I want to determine the row index that was
previously selected and scroll to that location.
Any help would be very much appreciated.
Thanks in advance,
Nicholas Allen
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-sql@postgresql.org
Cc: nallen@freenet.co.uk
Subject: Re: How do you select from a table until a condition is met?
In-Reply-To: <200302121910.38232.nallen@freenet.co.uk>
* 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