[storm] Query using count

Gustavo Niemeyer gustavo at niemeyer.net
Thu Aug 9 12:23:31 BST 2007


Hey Akira,

> Here I am again, you guys must be tired of this now. I installed the 

Nah, we're tough guys. ;-)

> psycopg2.ProgrammingError: column "_4.link" must appear in the GROUP BY 
> clause or be used in an aggregate function
> 
> Any ideas?

Yes, this is a requirement from postgres that you'll have to satisfy when
building the query by hand. "_4" is an alias for a table.  Have a look at
the query executed to spot how to please postgres.

-- 
Gustavo Niemeyer
http://niemeyer.net



More information about the storm mailing list