be a problem anymore.
Regards
Phil
De : Tom Lane
Envoyé : mardi 26 novembre 2019 01:39
À : Phil Florent
Cc : Pavel Stehule ; pgsql-hack...@postgresql.org
Objet : Re: GROUPING SETS and SQL standard
Phil Florent writes:
> A of () (called grand total in the Standard) i
Phil Florent writes:
> A of () (called grand total in the Standard) is
> equivalent to grouping the entire result Table;
Yeah, I believe so. Grouping by no columns is similar to what happens
if you compute an aggregate with no GROUP BY: the whole table is
taken as one group. If the table is e
TS and SQL standard
Hi,
Thank you, as you mentionned it's not really an interesting real life case
anyway.
Regards,
Phil
De : Pavel Stehule
Envoyé : lundi 25 novembre 2019 21:23
À : Phil Florent
Cc : pgsql-hack...@postgresql.org
Objet : Re: GROUPING SETS and SQL
Hi,
Thank you, as you mentionned it's not really an interesting real life case
anyway.
Regards,
Phil
De : Pavel Stehule
Envoyé : lundi 25 novembre 2019 21:23
À : Phil Florent
Cc : pgsql-hack...@postgresql.org
Objet : Re: GROUPING SETS and SQL standard
po 25. 11. 2019 v 20:32 odesílatel Phil Florent
napsal:
> Hi,
>
> We are still on the process to migrate our applications from proprietary
> RDBMS to PostgreSQL.
>
> Here is a simple query executed on various systems (real query is
> different but this one does not need any data) :
>
> Connected