Re: previous & next buttons

From: Bruno LEVEQUE <bruno(dot)leveque(at)net6d(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: previous & next buttons
Date: 2003-10-12 06:06:29
Message-ID: bmar0r$148m$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)leveque(at)net6d(dot)com
http://www.net6d.com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message David Benoff 2003-10-12 16:41:01 Deleting blob data with LargeObject Java API
Previous Message Psybar Phreak 2003-10-11 21:52:59 previous & next buttons