Re: Query size?

Check this do***entation 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@[EMAIL PROTECTED]
> 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@[EMAIL PROTECTED]
> 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
>

-- 
Sent via pgsql-jdbc mailing list (pgsql-jdbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc