On Tue, 13 Oct 1998, Bruce Momjian wrote:
> See the fetch manual page.<P>
OK, I will.
> This only prevents all row results from being transfered to the client.
Yes, this is good, but this is only half the problem ...
> The entire query must be evaluated, even if you only want just the first
... this is the other half.
> few rows. Consider a query that has an order by. There is no way
> to return any rows until the entire query is evaluated and sorted.
This is where I was hoping one of you guru types might have some insight,
-- how to stop short a query at X rows, even if it has an order by.
No way?
Terry Mackintosh <terry@terrym.com> http://www.terrym.com
sysadmin/owner Please! No MIME encoded or HTML mail, unless needed.
Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.3
-------------------------------------------------------------------
Success Is A Choice ... book by Rick Patino, get it, read it!