Re: [HACKERS] What about LIMIT in SELECT ?

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(at)terrym(dot)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!