> Strangely, this is the result we were expecting from our
> original query!
>
> Is it possible that the sub-selects are somehow
> affecting the result sets?
>
>
> Seen on:
> % postmaster --version
> postmaster (PostgreSQL) 7.1.3
>
> and
>
> % postmaster --version
> postmaster (PostgreSQL) 7.1.2
I think you want to upgrade, 7.3beta at least gives your
expected output on all the queries when I tried it. I don't
currently have a 7.2.* system to test on here to try it
with that series.