Tom Lane <tgl@sss.pgh.pa.us> writes:
> Are you sure this WHERE clause really expresses your intent? It seems
> awfully oddly constructed. Removing the redundant parens and clarifying
> the layout, I get
...
> That next-to-last major AND clause seems a rather unholy mix of join and
> restriction clauses; I wonder if it's not buggy in itself.
FYI RT uses a perl module called SearchBuilder which constructs these queries
dynamically. So he's probably not really free to fiddle with the query all he
wants.
At the very least I would suggest checking the changelog for SearchBuilder for
more recent versions. There have been a lot of tweaks for working with
Postgres. In the past it really only worked properly with MySQL.
--
greg