On 6/19/06, Alban Hertroys <alban(at)magproductions(dot)nl> wrote:
>
> I found a way that works, and is indeed quite a bit faster. It is even
> uglier than what you proposed. The problem wasn't the "order by" in the
> subquery, but the "order by" combined with the "union":
sorry, i always forget about the fact that union doesn't like internal
order and limits. subquery is of course perfectly fine - i'm glad you found
that :)
depesz
--
http://www.depesz.com/ - nowy, lepszy depesz