Tom Lane wrote: > "Karen Hill" <[EMAIL PROTECTED]> writes: > > -- Is there a way to know the total number of rows the cursor is > > capable of traversing without using --count? > > If you want an accurate count, the only way is to traverse the cursor. > Consider using MOVE FORWARD ALL and noting the rowcount, then MOVE > BACKWARD ALL to reset the cursor (the latter at least should be > reasonably cheap). >
Cool. Quick question, how does one go about noting the rowcount? Using the rowcount in get diagnostics or something else? regards, karen. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
