"Victor Yegorov" <viy@pirmabanka.lv> writes:
> I'm running `PostgreSQL 7.2 on i586-pc-linux-gnu, compiled by GCC 2.95.3'
> and have some problems with queries on a view.
Try 7.3. 7.2 won't push down WHERE conditions into a union.
BTW, if the archive table is disjoint from the main table, you'd be
better off using UNION ALL instead of UNION.
regards, tom lane