Re: pgbench - allow to create partitioned tables - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: pgbench - allow to create partitioned tables
Date
Msg-id alpine.DEB.2.21.1909181542450.32172@lancre
Whole thread Raw
In response to Re: pgbench - allow to create partitioned tables  (Dilip Kumar <dilipbalaut@gmail.com>)
List pgsql-hackers
> + "group by 1, 2 "
>
> I have a question, wouldn't it be sufficient to just group by 1?

Conceptually yes, it is what is happening in practice, but SQL requires 
that non aggregated columns must appear explicitely in the GROUP BY 
clause, so I have to put it even if it will not change groups.

-- 
Fabien.



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: another look at macOS SIP
Next
From: Robert Haas
Date:
Subject: Re: Minimal logical decoding on standbys