On Aug 24, 2005, at 6:31 AM, Bo Lorentsen wrote:
How sad, then I have to repeat the query, first for counting and last for data fetch :-(
No, you can use the MOVE command and read how many rows you moved with something like
MOVE LAST IN mycursor; http://www.postgresql.org/docs/8.0/interactive/sql-move.html John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
