Jamie,
> General issue: I'm getting cartesean products instead of left joins, and
> I feel like a moron.
No, this is extremely bizarre. I can't think of an explanation for the
results you're getting, except that the view definition isn't what you think
it is. Can you do a \d addenda and post the results?
--
-Josh BerkusAglio Database SolutionsSan Francisco