Cursors or Offset, Limit? - Mailing list pgsql-general

From Jerry LeVan
Subject Cursors or Offset, Limit?
Date
Msg-id 952F6175-371F-4C06-9B75-7AC88F1BF045@EKU.EDU
Whole thread Raw
Responses Re: Cursors or Offset, Limit?  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-general
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 are some of the tradeoffs between using a cursor and using the
limit/offset method of selecting rows to display?

Thanks,

Jerry

pgsql-general by date:

Previous
From: Michelle Konzack
Date:
Subject: Re: 3 x PostgreSQL in cluster/redunant
Next
From: Bruce Momjian
Date:
Subject: Re: invalid UTF-8 byte sequence detected