Re: previous & next buttons - Mailing list pgsql-novice

Hi,

If I well understand what you want, you need a select query like :


select * from TheTable limit x offset y


With "<<Previous y y+1 y+2 y+3 .. y+x >>Next"

Bruno


Psybar Phreak wrote:

>hi all,
>
>im developing a site in perl with mason on a postgreSQL backend.
>
>i currently have a page that lists all items in a table, but would like to
>do the
>" << PREVIOUS  1  2  3  4   NEXT>> "
>
>sort of thing - say LIMIT of 10 records to a page.
>
>can someone help me out.
>
>thanks
>
>PP
>
>
>
>
>
>

--
Bruno LEVEQUE
System Engineer
SARL NET6D
bruno.leveque@net6d.com
http://www.net6d.com