Re: Subselect returns too many attributes - Mailing list pgsql-novice

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