From: | Jens Felber <jfe(at)gek-online(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | RE: [GENERAL] changing between 6.4.1 and 6.5 |
Date: | 1999-08-26 06:38:39 |
Message-ID: | 3.0.6.32.19990826083839.0090bda0@62.156.187.1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Stuart Rison | 1999-08-26 09:03:24 | RE: [GENERAL] changing between 6.4.1 and 6.5 |
Previous Message | amy cheng | 1999-08-26 06:09:39 | Re: [GENERAL] Hardware optimising |