How to get "next" record in a recordset

See furthur down...

On Tue, Sep 10, 2002 at 10:26:53AM +0200, Peter Alberer wrote:

I am developing a testing application for the web where students can
navigate thru multiple choice quizzes. Of course there should be a
button to go to the next question (by alphabet, random, categories) My
problem is how to get the �next� question of a certain recordset. For
example:

select
lro.lr_object_id, lro.lr_title
from lr_objects lro, acs_rels
where object_id_one = '10524'
and rel_type= 'lr_concept_rel'
and object_id_two = lro.lr_object_id
and lro.is_active='t'
and restype = 'excs'
order by lro.lr_title;

Something like:

select min(lr_object_id) from lr_objects where lr_object_id > 13742;

or maybe you can use limit.

lr_object_id | lr_title
--------------+--------------------------------------------
14617 | �bungsaufgabe 2-31
14614 | �bungsaufgabe 2-32
13226 | Attacken von Free-Software-Programmen
13297 | Aussagen �ber Computerviren
13300 | Aussagen �ber Computerviren
13311 | Aussagen �ber Makros
13316 | Aussagen �ber Virusprogramme
13235 | Aussagen im Zusammenhang mit Computerviren
13400 | Computerviren
13742 | Ma�nahmen zum Schutz vor Computerviren
13768 | M�gliche F�lle von Computerviren
13774 | M�glichkeit eines Virenbefalls
13809 | PC-Programm: "Swiss Ph�nix"
13850 | Regelm��ige Viren�berpr�fung
14071 | Warnung im Computermagazin

I can not order by lr_object_id. If the lr_object_id of the current
question is 13742 how can I retrieve the next lr_object_id with one
sql-query? I have created a function (plpgsql) to get the next id but
can it be done an easier way?

TIA, peter alberer

--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/