Re: [HACKERS] SELECT ... LIMIT (trial implementation)

Oleg Bartunov wrote:

>
> Jan,
>
> I tested your patch on my Linux box and it works ok, except
> aggregates functions doesn't work properly, for example
> count(*) always produces 0

They work absolutely properly :-)

>
> kdo=> select count(*) from work_flats limit 10,1000;
> count
> -----
> (0 rows)

As I wrote, the executor skips final result rows. In the
obove query, there is only one result row (the one returned
by the aggregate function). You asked the executor to skip it
and it did.

We cannot limit selections in deeper levels than the top one.
This would give unpredictable results in joins.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #