> 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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
