On Monday 27 May 2002 20:02, Tom Lane wrote:
>
> If that actually has the behavior you want, then that's the way you
> write it. Placing restrictions inside an outer join is not semantically
> the same as placing them outside (at the WHERE clause), so it wasn't
> clear to me exactly what you wanted.
>
Ah, that explains why I couldn't figure it out.
I think I need to move on from my current Postgres Bible, it stops short of
full outer joins :-(
Thanks
JohnT