Outer joins will work, but I think that we would like to keep openacs 3.2.x compatible with postgresql 7.0.x. See this recent thread about fixing problems with order by in unions due to using pg 7.1. There have been several contributions to the cvs sources to help make openacs compatible with pg 7.1.
