On Tue, Feb 25, 2003 at 02:04:50PM +0100, Christoph Haller wrote: > > Anyway, you may MOVE until 0 instead of FETCH, or use the COUNT() > function on the query to learn about the number of rows to be returned.
Hmm... Wouldn't the reliability of a count() depend on the isolation level? OTOH the problem with MOVE ALL is that not all cursors support backward scrolling, apparently, and there is no clear documentation (or even diagnostics!) to determine whether they do. Jeroen ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org