On Tuesday 28 March 2006 10:05, Martijn van Oosterhout wrote:
> That's because it's decribed in the SQL standard. UNION ALL just joins
> the results of the two queries. UNION removes duplicates which usually
> means sorting and comparing the tuples. UNION ALL is faster and usually
> what you want anyway...
Yes that's exactly what I want. Thanks for pointing out the difference
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
