I use both OFFSET + LIMIT, allowing to have a link to the next X tuples.
Just set newoffset=currentoffset+limit for the next query.
Nicolas Huillard
-----Message d'origine-----
De: Chris Albertson [SMTP:[EMAIL PROTECTED]]
Date: mercredi 15 mars 2000 05:22
À: Ruben Fagundo
Cc: [EMAIL PROTECTED]
Objet: Re: [ADMIN] Reducing the search results to a certain number of results -i.e.
10 per page
Ruben Fagundo wrote:
>
> We are developing a Postgres web application that would return "X" results at a
>time? Is this something that can be handled in Postgres, where we can ask for
>results, 10 at a time, or something like this? I've seen it done on other web sites,
>but I don't know if it's something they do at the database level, or in the
>application.
Quoted from "man select" Note the LIMIT clause. Yes you could do this
in the application but then you'd have to use cookies.
+++++++++++++ begin quote +++++++++++++++
SELECT(l) SELECT(l)
NAME
SELECT - Retrieve rows from a table or view.
SYNOPSIS
SELECT [ ALL | DISTINCT [ ON column ] ]
expression [ AS name ] [, ...]
[ INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table ]
[ FROM table [ alias ] [, ...] ]
[ WHERE condition ]
[ GROUP BY column [, ...] ]
[ HAVING condition [, ...] ]
[ { UNION [ ALL ] | INTERSECT | EXCEPT } select ]
[ ORDER BY column [ ASC | DESC ] [, ...] ]
[ FOR UPDATE [ OF class_name... ] ]
[ LIMIT { count | ALL } [ { OFFSET | , } count ] ]
--
Chris Albertson
[EMAIL PROTECTED] Voice: 626-351-0089 X127
Logicon, Pasadena California Fax: 626-351-0699
