> I have a query which worked OK until now (with all the previous versions
> of PostgreSQL) but now it returns the following error message:
>
> 'Illegal use of aggregates or non-group column in target list'
>
> So what has been changed at GROUP BY in 6.5?
>
>
The target list can contain only aggregates(ie sum), or grouped by
columns.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026