Query size?

From: Paul Tomblin <ptomblin(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Query size?
Date: 2008-06-22 11:38:49
Message-ID: 485E39C9.8050006@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I'm working with another developer to produce an iPhone app - he's writing the
app and I'm writing the server that provides the data to it. One of the
queries he's doing might produce hundreds or thousands of results, and he
doesn't want me sending that much data.

So I'm wondering if there is a simple way to determine if a query is going to
produce a result of more than N rows? Is the only way to do a "select
count(*)" query first, or there something in the ResultSet that tells me how
many results are queued up?

--
Paul Tomblin <ptomblin(at)xcski(dot)com> http://blog.xcski.com/
God is real, unless declared as an integer.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message imad 2008-06-22 12:23:36 Re: Query size?
Previous Message Max Pyziur 2008-06-21 14:29:18 Re: free ETL tool for files, using postgreSQL and jdbc driver