Jose Soares <jose(at)sferacarta(dot)com> writes:
> SELECT...HAVING, this last for example doesn't work.
That's a rather strong statement, and in fact a provably false one.
How about a detailed bug report rather than "it doesn't work"?
> SELECT ... UNION (is 3 / 4 times slow)
Can't help you on that without more details, either. What is the
query exactly, what plan does EXPLAIN show, and what plan did you
get from 6.5?
regards, tom lane