Re: MOVE doesn't return number of rows

Phil Endecott <spam_from_postgresql_general@chezphil.org> writes:
> According to the documentation for MOVE, it returns the number of rows
> that it has moved over.

That's a documentation bug.  CVS tip has the correct explanation:

    The count is the number of rows that a FETCH command with the same
    parameters would have returned (possibly zero).

> What I'm actually trying to do is to find the number of rows in the
> query result.  I was hoping to be able to do a "MOVE ABSOLUTE -1" to get
> this.  Any other suggestions?

MOVE FORWARD ALL.

            regards, tom lane