I am writing a function to interrogate the database and get a total row
count of rows matching the critera of a search, and then return a subset
of those rows. This is to satisfy the familiar web <page> of <pages>
situation.
At the moment I call the query twice, one with limit and offset
statements, the other without these. I use ROW_COUNT after the second.
Is it possible to do a query, get the ROW_COUNT, and then use a cursor
or something similar to get the subset into a setof result%rowtype?
Thanks!
Rory
--
Rory Campbell-Lange
<rory@campbell-lange.net>
<www.campbell-lange.net>