Get a row by it's number from (re)select - Mailing list pgsql-novice

From Boszormenyi Laszlo
Subject Get a row by it's number from (re)select
Date
Msg-id Pine.LNX.4.21.0007201315320.1844-100000@jupiter.hlab.uni-miskolc.hu
Whole thread Raw
In response to Re: Get a row by it's number  (Phil Meadway <philip.meadway@esmltd.co.uk>)
List pgsql-novice
Hello!

On Thu, 20 Jul 2000, Phil Meadway wrote:

> Do you want to retrieve the nth row from
> a select ... order by statement? Or are you looking for the nth row added? Nth
> row added can be achieved if you use an incrementing sequence counter when
> adding.

 To simplify the things, I do something like this:
execute a 'select * from mytable' from a cgi, then I write one of the
columns into options (the html tag). I generate unique name for them
ofcourse. When you submit your choice, an other cgi would display the full
row for that entry.
I know it can be done with the where clause too, but I'm intrested.

Thanks the help,
    Laszlo Boszormenyi


pgsql-novice by date:

Previous
From: Andrew McMillan
Date:
Subject: Re: Get a row by it's number
Next
From: "luc00"
Date:
Subject: Please the SET DIGEST command topic [by email]