Cursors or Offset, Limit?

From: Jerry LeVan <Jerry(dot)Levan(at)EKU(dot)EDU>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Cursors or Offset, Limit?
Date: 2005-11-15 18:44:32
Message-ID: 952F6175-371F-4C06-9B75-7AC88F1BF045@EKU.EDU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-11-15 18:46:02 Re: invalid UTF-8 byte sequence detected
Previous Message Michelle Konzack 2005-11-15 18:38:06 Re: 3 x PostgreSQL in cluster/redunant