Re: how many tuples on a cursor?

From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andreas Kretschmer <akretschmer(at)despammed(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: how many tuples on a cursor?
Date: 2005-05-02 15:20:32
Message-ID: 42764540.EDC0C34C@rodos.fzk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom Lane wrote:
>
> Christoph Haller <ch(at)rodos(dot)fzk(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stéphane RIFF 2005-05-02 15:36:05 Query two database at once
Previous Message Tom Lane 2005-05-02 15:04:09 Re: how many tuples on a cursor?