From: Dmitry Tkach <dmitry@openratings.com>
To: Nicholas Allen <nallen@freenet.co.uk>
Subject: Re: How do you select from a table until a condition is met?
Date: Wed, 12 Feb 2003 15:39:03 -0500
Message-ID: <3E4AB0E7.3010101@openratings.com> (raw)
In-Reply-To: <200302121910.38232.nallen@freenet.co.uk>
References: <200302121910.38232.nallen@freenet.co.uk>
select * from table order by x limit 10; -- get first 10
select * from table order by x offset 10 limit 10; -- get 10 - 20
select * from table order by x offset 40 limit 10; -- get 40-50
OR
begin;
declare mycursor cursor for select * from table order by x;
fetch 10 from mycursor; -- get first 10
fetch 10 from mycursor; -- get 10-20
move 20 in mycursor;
fetch 10 from mycursor; -- get 40-50
Is that what you are talking about?
Dima
Nicholas Allen wrote:
> Hi,
>
> I am hoping that someone can help me with a problem I have. I would like to=
> be=20
> able to perform a SELECT query to select values from a table upto a certain=
> =20
> row. The select may be ordered on a number of items. Is it possible to do=
> =20
> this and how should I do it?
>
> The reason I need this is because I have created a virtual table browser cl=
> ass=20
> that performs SQL queries to get the sections of the table the user is=20
> interested in. This way I don't load the whole table onto the client side. =
> If=20
> the user changes the sort ordering I want to determine the row index that w=
> as=20
> previously selected and scroll to that location.
>
> Any help would be very much appreciated.
>
> Thanks in advance,
>
> Nicholas Allen
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
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: dmitry@openratings.com, nallen@freenet.co.uk
Subject: Re: How do you select from a table until a condition is met?
In-Reply-To: <3E4AB0E7.3010101@openratings.com>
* 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