Postgres Pro
Downloads
Home   >   mailing lists

Re: MOVE doesn't return number of rows - Mailing list pgsql-general

From Tom Lane
Subject Re: MOVE doesn't return number of rows
Date
Msg-id 6567.1094747288@sss.pgh.pa.us
Whole thread Raw
In response to MOVE doesn't return number of rows  (Phil Endecott <spam_from_postgresql_general@chezphil.org>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: How to determine a database is intact?
Next
From: Frank Finner
Date:
Subject: Re: Upgrading PostgreSQL 7.1.3