RE: [GENERAL] changing between 6.4.1 and 6.5

At 18:02 25.08.99 +0200, you wrote:
>have You set any triggers, rules, listens or defaults for tablex?
>


Nothing is set. I create a new table for tests.

 --> create table test1 (x1 int2, x2 int2, tx char);

then I've inserted some values:

--> insert into test1 values (1,2, 'a');
--> insert into test1 values (1,2, 'b');
--> insert into test1 values (1,3, 'b');
--> insert into test1 values (1,4, 'b');
--> insert into test1 values (2,2, 'b');
--> insert into test1 values (2,3, 'b');

after that I want a select with group by:

--> select * from test1 group by x1, x2;

ERROR: illegal use of aggregate or non-group column in target list

I believe, that all fields are in group column, but what means target list:
is it the native table test1 or is mean  the output list, which is seen on
screen
after the statement?

And another part is: the same table and the same statement bring out the
correct values in a postgreql v6.4.x . Why not in v6.5?

Jens