On 10/16/06, Alban Hertroys <alban@magproductions.nl> wrote:
> Merlin Moncure wrote:
> > for server side browsing use cursors or a hybrid pl/pgqsl loop. for
> > client side, browse fetching relative to the last key:
> >
> > select * from foo where p > p1 order by p limit k;
>
> This does require some way for the client to keep a single transaction
> open. If this kind of query is performed by a web application (as is
> often the case), the "client" is the server side web script engine, and
> not all of those beasts are capable of keeping a transaction open across
> pages (PHP comes to mind).
> This combined with expensive (complex) queries is regularly a pain.
Server-side browsing requires transactions so is unsuitable for
certain types of web enviroments. However client-side following as I
described as not...it is the right and proper way to solve this
problem . It's also why the sql row-wise comparion is so important,
because it provides an easy way to do this with table with mutiple
part keys.
merlin