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 Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
