From: | imad <immaad(at)gmail(dot)com> |
---|---|
To: | "Paul Tomblin" <ptomblin(at)gmail(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Query size? |
Date: | 2008-06-22 12:55:02 |
Message-ID: | 1f30b80c0806220555y5523933cybaf6b79000924a30@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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(at)gmail(dot)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(at)xcski(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-06-22 18:56:18 | Re: Query size? |
Previous Message | Paul Tomblin | 2008-06-22 12:37:29 | Re: Query size? |