Re: Getting ROW_COUNT from MOVE in 8.3

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "Reuven M(dot) Lerner" <reuven(at)lerner(dot)co(dot)il>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Getting ROW_COUNT from MOVE in 8.3
Date: 2010-10-24 18:25:26
Message-ID: 1287944726.24847.0.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On sön, 2010-10-24 at 15:41 +0200, Reuven M. Lerner wrote:
> But is there any way for me to get, in 8.3, the
> number of rows over which a cursor has skipped? Keep in mind that
> after
> this count has executed, we're then going to rewind the cursor,
> chunking
> through the result set with a separate function.

You could store the query result in a temporary table.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Figueiredo Jr. 2010-10-24 19:45:49 Re: Windows 2008/IIS cannot connect to Postgres 9.0
Previous Message Tom Lane 2010-10-24 16:33:57 Re: What is "return code" for WAL send command