Hi
The advantage is, that we can initalize more resultsets, not have to allocate memory and not have to query count(*) statements.Please never use 'SELECT COUNT(*)', the performance of Postgres' count(*) is horrible. 'explain analyze select count(*) from dbmail_messages' takes 600ms for my 60000 rows ...
As I wrote, with the 'stmt' parameter, we not have to use count(*) statements. The first 2500 of about 4000 rows are translated. :-) I will send a mail, if it works. Dominik
