On Thu, Aug 16, 2007 at 01:09:32PM +0200, Rainer Bauer wrote: > Anyway, what Phoenix is trying to say is that 2 queries are required: One to > get the total count and one to get the tuples for the current page. I reckon > it would help, if the query returning the result set could also report the > total no. of tuples found. Somthing like > SELECT COUNT(*), * FROM <table> WHERE <cond> OFFSET <o> LIMIT <l> Well, thee is another possibility, use cursors: DECLARE CURSOR ... AS <query>; FETCH 30 -- or however many to want now MOVE TO END -- or whatever the command is, this gives you the number of rows Hope this helps, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
