From: | Pantelis Theodosiou <ypercube(at)gmail(dot)com> |
---|---|
To: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | DISTINCT term in aggregate function |
Date: | 2021-03-18 18:03:03 |
Message-ID: | CAE3TBxyiC0ivwhAVAeL8C8G6UUpyQ+WKUrEnRZ7LsE-LRXzR8A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-hackers |
Hi, I didn't think of including you in this suggestion.
Or the pdsql-docs was not the right list to post? I didn't want to mix it
with the GROUP BY DISTINCT patch.
Please check my suggestion.
Best regards
Pantelis Theodosiou
---------- Forwarded message ---------
From: Pantelis Theodosiou <ypercube(at)gmail(dot)com>
Date: Sat, Mar 13, 2021 at 1:03 AM
Subject: Fwd: GROUP BY DISTINCT
To: <pgsql-docs(at)lists(dot)postgresql(dot)org>
---------- Forwarded message ---------
From: Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
Date: Fri, Mar 12, 2021 at 11:33 PM
Subject: Re: GROUP BY DISTINCT
To: Vik Fearing <vik(at)postgresfriends(dot)org>, Georgios Kokolatos <
gkokolatos(at)protonmail(dot)com>, <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Erik Rijkers <er(at)xs4all(dot)nl>
Hi Vik,
The patch seems quite ready, I have just two comments.
1) Shouldn't this add another <indexterm> for DISTINCT, somewhere in the
documentation? Now the index points just to the SELECT DISTINCT part.
.....
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
After reading the above thread in hackers, I noticed that the index does
not point to aggrgeate functions either and DISTINCT is not mentioned in
the aggregate functions page either:
https://www.postgresql.org/docs/current/functions-aggregate.html
Shouldn't it be mentioned with an example of COUNT(DISTINCT ...) or
aggregate_function(DISTINCT ...) in general ?
Best regards
Pantelis Theodosiou
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2021-03-18 18:05:52 | Re: DISTINCT term in aggregate function |
Previous Message | Tomas Vondra | 2021-03-18 17:25:47 | Re: GROUP BY DISTINCT |
From | Date | Subject | |
---|---|---|---|
Next Message | John Naylor | 2021-03-18 18:05:32 | Re: Perform COPY FROM encoding conversions in larger chunks |
Previous Message | Tomas Vondra | 2021-03-18 17:51:17 | Re: cleanup temporary files after crash |