On Tue, Nov 15, 2005 at 01:44:32PM -0500, Jerry LeVan wrote:
>
> What are some of the tradeoffs between using a cursor and using the
> limit/offset method of selecting rows to display?
OFFSET actually has to scan all the preceding rows every time (plus
to get it consistently, you need to do an OR
Hi,
I am mucking around trying to build a gui'sh "table editor" for
Postgresql.
I am currently using a "held" cursor to move around the table, Since the
"cursor" does not show table modification I am thinking about using the
"limit" and "offset" attributes to select the rows to display.
What