Postgres Pro
Downloads
Home   >   mailing lists

Re: how many tuples on a cursor? - Mailing list pgsql-sql

From Christoph Haller
Subject Re: how many tuples on a cursor?
Date
Msg-id 42764540.EDC0C34C@rodos.fzk.de
Whole thread Raw
In response to how many tuples on a cursor?  (Andreas Kretschmer <akretschmer@despammed.com>)
List pgsql-sql
Tree view 
Tom Lane wrote:
> 
> Christoph Haller <ch@rodos.fzk.de> writes:
> > What else seems to work is MOVE 2147483647
> > (INT_MAX) and then get the max number of rows
> > by PQcmdTuples().
> 
> I'd suggest "MOVE FORWARD ALL" rather than hard-wiring assumptions
> about the maximum possible value of infinity ;-)
> 

Of course. I should have read the manual on this more carefully. 

Regards, Christoph

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: how many tuples on a cursor?
Next
From: Stéphane RIFF
Date:
Subject: Query two database at once