24 Apr
2008
24 Apr
'08
3:12 p.m.
postgres log reports: ERROR: column "s.tax_str" must appear in the GROUP BY clause or be used in an aggregate functionSTATEMENT: select s.tax_group_1, s.tax_group_2, s.tax_group_3, s.tax_str, count(*) as num from ( select id1, min(rank_psc) as rank from tax_sim_570 where dbid=6 and logpsc<=-100 group by id1) as b inner join tax_sim_570 as s on b.id1=s.id1 and b.rank=s.rank_psc where dbid=6 group by s.tax_group_1, s.tax_group_2, s.tax_group_3
6722
Age (days ago)
6722
Last active (days ago)
0 comments
1 participants
participants (1)
-
Robert Olson