Обсуждение: changing between 6.4.1 and 6.5

Hi List,

after an installation of PostgrSQL v6.5 on a new machine
i have problems with a view which is running without problems
under 6.4.x.
But the view isn't the problem. The same statement on the real table
realized the same error:
ERROR: illegal use of aggregate or non-group column in target list
(aggregates are not existing in my database)

Statement:  select x1, x2, x3, x4 on tablex order by x1, x2;

Know anybody somthing about that kind  of changing if it is a real one.

by Jens

Hi,

>after an installation of PostgrSQL v6.5 on a new machine
>i have problems with a view which is running without problems
>under 6.4.x.
>But the view isn't the problem. The same statement on the real table
>realized the same error:
>ERROR: illegal use of aggregate or non-group column in target list
>(aggregates are not existing in my database)
>
>Statement:  select x1, x2, x3, x4 on tablex order by x1, x2;
                                  ^^^^

Try: select x1, x2, x3, x4 FROM tablex order by x1, x2;

I have no idea why you get an 'aggregate' error message.  My version
(PG6.4.0) throws a syntax error!

HTH,

S.

+--------------------------+--------------------------------------+
| Stuart C. G. Rison       | Ludwig Institute for Cancer Research |
+--------------------------+ 91 Riding House Street               |
| N.B. new phone code!!    | London, W1P 8BT                      |
| Tel. +44 (0)207 878 4041 | UNITED KINGDOM                       |
| Fax. +44 (0)207 878 4040 | stuart@ludwig.ucl.ac.uk              |
+--------------------------+--------------------------------------+

At 13:02 25.08.99 +0100, Stuart Rison wrote:
>Hi,
>
>>realized the same error:
>>ERROR: illegal use of aggregate or non-group column in target list
>>(aggregates are not existing in my database)
>>
>>Statement:  select x1, x2, x3, x4 on tablex order by x1, x2;
                                                       ^^^^^^
sorry, there was a mistake : it must be from not on
But the problem is the same.

by Jens