Check this documentation out. It does what you want, but in an efficient way.
http://doc.postgresintl.com/jdbc/ch04.html#jdbc-query-with-cursor
--Imad
On Sun, Jun 22, 2008 at 10:37 PM, Paul Tomblin <ptomblin@gmail.com> wrote:
> imad wrote:
>>
>> Why dont you adopt a pro-active aproach here and append a LIMIT to
>> every query you send to the server?
>> You can do an OFFSET LIMIT combination of all queries until you get
>> results less than LIMIT.
>
> What I'm asking though is if there is some way to know before I start
> returning results, short of doing a "COUNT(*)" first.
>
>
> --
> Paul Tomblin <ptomblin@xcski.com> http://blog.xcski.com/
> We're the technical experts. We were hired so that management could
> ignore our recommendations and tell us how to do our jobs.
> -- Mike Andrews
>