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

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Nicholas Allen <nallen(at)freenet(dot)co(dot)uk>
Cc: Dmitry Tkach <dmitry(at)openratings(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: How do you select from a table until a condition is met?
Date: 2003-02-12 20:37:49
Message-ID: 20030212203749.GA30483@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Feb 12, 2003 at 20:55:21 +0100,
Nicholas Allen <nallen(at)freenet(dot)co(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dmitry Tkach 2003-02-12 20:39:03 Re: How do you select from a table until a condition is met?
Previous Message Nicholas Allen 2003-02-12 20:00:11 Re: How do you select from a table until a condition is met?