> But the message I was replying to was a similar union query, and I was > thinking that that person might be having a similar initial intuitive > reaction, "well, it looks kinda the same." I just wanted to note that > you need to check this stuff with explain, rather than > blindly assuming > you know what's going on.
I had a "union all" view, which is actually a quite different animal than a "union" view which needs to eliminate duplicates before further processing. Andreas ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html