Tom Lane schrieb:
At least for me this is surprising!
Why do you find it surprising? Per spec, the SELECT output list is not
evaluated at rows that fail the WHERE clause. This must be so; consider
examples like
SELECT 1/x FROM t WHERE x <> 0;
Of ocurse!
I think what you need i
Hallo all
During a performance tuning session I had a complex
query that gives some form of ranking. The "correct" way to
solve this, is the use of a scalar subquery that provides
the rank (or use "dense_rank over" in oracle).
But in my case the query is much too slow in this special case.
Even
