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.
In response to
pgsql-sql by date
|Next:||From: Chester Kustarz||Date: 2004-01-28 20:12:38|
|Subject: Re: Question about isolation|
|Previous:||From: Samuel Tardieu||Date: 2004-01-28 17:58:53|
|Subject: Question about isolation|