[SQL] how many tuples on a cursor?

Hello, I want to know how many tuples there on a cursor, and i found http://groups.google.de/groups?hl=delr=threadm=3ACA7BB0.7020106%402cactus.comrnum=7prev=/groups%3Fhl%3Dde%26lr%3D%26q%3Dpostgres%2Bcursor%2Bcount%26btnG%3DSuche But, this posting is very old (2001-04-03), i'm using 7.4.6. Is

Re: [SQL] how many tuples on a cursor?

Andreas Kretschmer wrote: Hello, I want to know how many tuples there on a cursor, and i found http://groups.google.de/groups?hl=delr=threadm=3ACA7BB0.7020106%402cactus.comrnum=7prev=/groups%3Fhl%3Dde%26lr%3D%26q%3Dpostgres%2Bcursor%2Bcount%26btnG%3DSuche But, this posting is very old

Re: [SQL] how many tuples on a cursor?

Christoph Haller [EMAIL PROTECTED] 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 ;-) But I have no idea how

Re: [SQL] how many tuples on a cursor?

Tom Lane wrote: Christoph Haller [EMAIL PROTECTED] 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