Postgres Pro
Downloads
Home   >   mailing lists

Re: How do you select from a table until a condition is met? - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: How do you select from a table until a condition is met?
Date
Msg-id 20030212203749.GA30483@wolff.to
Whole thread Raw
In response to Re: How do you select from a table until a condition is met?  (Nicholas Allen <nallen@freenet.co.uk>)
Responses Re: How do you select from a table until a condition is met?  (Nicholas Allen <nallen@freenet.co.uk>)
List pgsql-sql
Tree view 
On Wed, Feb 12, 2003 at 20:55:21 +0100, Nicholas Allen <nallen@freenet.co.uk> wrote:
> I thought of this but the problem is that there may be multiple rows with the 
> same value for the column I am sorting on. Eg if sorting on a surname then 
> there may be 100s of people with the same surname so generating a where 
> clause that selects up to the exact person previously selected is very 
> difficult.

Then you should sort on surname AND whatever you are using as the primary key.

pgsql-sql by date:

Previous
From: Nicholas Allen
Date:
Subject: Re: How do you select from a table until a condition is met?
Next
From: Dmitry Tkach
Date:
Subject: Re: How do you select from a table until a condition is met?