Stephan Szabo <[EMAIL PROTECTED]> writes: > On Tue, 19 Nov 2002, Chris Gamache wrote: >> Understood. PostgreSQL 7.2.3.
> 7.3 will be better for this. There were questions about the safety > of pushing clauses down in queries with union and intersect and > earlier versions wouldn't push down because we weren't sure it was > safe. Except will still be problematic, but union and intersect should be > much happier. Yeah, the UNIONs in the view are definitely the big problem. Can you try on 7.3rc1 and see how it goes? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly