From: Bruno Wolff III <bruno@wolff.to>
To: Nicholas Allen <nallen@freenet.co.uk>
Cc: Dmitry Tkach <dmitry@openratings.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: How do you select from a table until a condition is met?
Date: Wed, 12 Feb 2003 13:35:38 -0600
Message-ID: <20030212193538.GA29724@wolff.to> (raw)
In-Reply-To: <200302122010.15297.nallen@freenet.co.uk>
References: <200302121910.38232.nallen@freenet.co.uk>
<3E4AB0E7.3010101@openratings.com>
<200302122010.15297.nallen@freenet.co.uk>
On Wed, Feb 12, 2003 at 20:10:15 +0100,
Nicholas Allen <nallen@freenet.co.uk> wrote:
>
> Thanks, but I don't think thats what I want. Basically I need to get the row
> offset of a record (ie row) in a result set returned from the database. I
> know all the details of the row in question but when the search order changes
> I need to know the new index the row will have.
>
> In other words, I was hoping I would be able to select upto a particular row
> (not knowing its offset but knowing everything else about it) in a select
> query.
>
> Ideally I could do something like SELECT count(*) UNTIL col1=value1 &&
> col2=val2 etc....
Since you are ordering the data you can use where clauses with < (and/or >)
operators to stop counting at the desired row. For this to work the ordering
needs to be well defined. You can tack on the primary key to your list
of columns to order by to make the ordering well defined if it isn't
already.
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: bruno@wolff.to, nallen@freenet.co.uk, dmitry@openratings.com
Subject: Re: How do you select from a table until a condition is met?
In-Reply-To: <20030212193538.GA29724@wolff.to>
* 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