How do you select from a table until a condition is met?

From: Nicholas Allen <nallen(at)freenet(dot)co(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: How do you select from a table until a condition is met?
Date: 2003-02-12 18:10:38
Message-ID: 200302121910.38232.nallen@freenet.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Nicholas Allen 2003-02-12 19:10:15 Re: How do you select from a table until a condition is met?
Previous Message Dmitry Tkach 2003-02-12 17:55:22 Re: timestamp