Thanks for explanation.
Now I remember the discussion on hackers list about this feature, but
anyway, this feature surprised little bit.
G.
Gra*vydas Valeika wrote:
>> This is because PostgreSQL 9.1 added the feature of simple
>> checking of functional dependencies for GROUP BY. The manual of
>> 9.1 explains quite well when PostgreSQL considers there to be a
>> functional dependency.
>>
>> "When GROUP BY is present, it is not valid f
>
>
> This is because PostgreSQL 9.1 added the feature of simple checking of
> functional dependencies for GROUP BY. The manual of 9.1 explains quite well
> when PostgreSQL considers there to be a functional dependency.
>
> "When GROUP BY is present, it is not valid for the SELECT list expressions
On 2012-01-19 00:25, Gražvydas Valeika wrote:
In PG 9.0 this script complains that: column "aaa.something" must appear
in the GROUP BY clause or be used in an aggregate function. Sorry, don't
have 9.0 at my hands, but error message is similar to quoted.
Same error is raised in 9.1 when ', constra
Hi,
accidentally found a our sql typo, which runs without errors on pg 9.1, but
raises error on 9.0. It seems to me, that 9.0 behaviour was correct.
Reproducing case:
create table aaa(id integer NOT NULL, something double precision,
constraint pk_aaa primary key (id));
insert into aaa values (1,
