I wrote:
> "Scott Muir" <wsmuir@islandnet.com> writes:
>> when I view it again either from pgaccess or using psql, the subselect has
>> had added to the fields it returns, all the other fields in the group by or
>> in the where clause... this still seems to work okay..
> This is a bug ... it's fixed in 7.1 ...
Hm, I didn't actually answer your question, did I? Yes, the view
will work fine. The bug is just in the rule decompiler: it's showing
parts of the internal representation that it shouldn't.
regards, tom lane