> yep. This is because one of the advantages of a cursor is that it only
> runs partially and returns the first X rows for the fetch. This keeps
> load down so that many cursors hitting the machine at once don't all
> materialize all their rows and chew up all that I/O, cpu, and memory.
> Unfort
> Not without actually scanning the result, if that's what you meant.
so basically i have to do a move to the end ?
---(end of broadcast)---
TIP 8: explain analyze is your friend
When declaring a cursor is there a way to return the number of rows that
the declared cursor consists of ?
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTE
o do a select count(*) on the query
i use to create the cursor?
/ Christoffer Gurell
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "
could transfer just the information
currently displayed and not the entire result.
Is this possible or do i have to do a (create temp table as select ...) and
then do (select ... limit ..) in this temporary table?
This would work but i dont think it's a very good solution.
/ Christ
