Use OFFSET and LIMIT on your queries.
http://www.postgresql.org/idocs/index.php?queries-limit.html
Dave
angelo.rigo@globo.com wrote:
>hi
>
>I want to do a selection from a table giving it a limit of records to be
>displayed and the previous and next buttons to navigate through the results
>anybody has it made for php postgresql?
>
>
>________________________________________
>A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br.
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>