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