Skip site navigation (1) Skip section navigation (2)

Re: Aggregate function error in 7.4

From: j knight <enabled(at)myrealbox(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Aggregate function error in 7.4
Date: 2004-01-28 19:18:27
Message-ID: 40180B03.3070209@myrealbox.com (view raw or flat)
Thread:
Lists: pgsql-sql
Tom Lane wrote:
> j knight <enabled(at)myrealbox(dot)com> writes:
> 
>>[ query with GROUP BY on a FULL JOIN USING column ]
>>psql:pgsql.dump:301: ERROR:  column "r.day" must appear in the GROUP BY 
>>clause or be used in an aggregate function
> 
> 
> Argh.  This is the result of a thinko in an optimization added in 7.4.
> The patch is attached...

Thank you Tom. This does indeed solve the problem.



.joel

In response to

pgsql-sql by date

Next:From: Chester KustarzDate: 2004-01-28 20:12:38
Subject: Re: Question about isolation
Previous:From: Samuel TardieuDate: 2004-01-28 17:58:53
Subject: Question about isolation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group