Re: GROUP BY DISTINCT

From: Georgios <gkokolatos(at)protonmail(dot)com>
To: Vik Fearing <vik(at)postgresfriends(dot)org>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Erik Rijkers <er(at)xs4all(dot)nl>
Subject: Re: GROUP BY DISTINCT
Date: 2021-03-02 19:21:42
Message-ID: AxJsCzbFuyPfQckgXQ-HOMFvSqwMFszDbEJglCEe0Nijjn8tjNoNvbTGgjlfmZoPF7zhdW_ZwIdMvL1N8x44RTYnmpe3GzGRDE4tGIymuec=@protonmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Tuesday, March 2, 2021 5:51 PM, Vik Fearing <vik(at)postgresfriends(dot)org> wrote:

> On 3/2/21 4:06 PM, Georgios Kokolatos wrote:
>
> > As a minor gripe, I would note the addition of list_int_cmp.
> > The block
> >
> > - /* Sort each groupset individually */
> >
> >
> > - foreach(cell, result)
> >
> >
> > - list_sort(lfirst(cell), list_int_cmp);
> >
> >
> >
> > Can follow suit from the rest of the code, and define a static cmp_list_int_asc(), as
> > indeed the same patch does for cmp_list_len_contents_asc.
> > This is indeed point of which I will not hold a too strong opinion.
>
> I did it this way because list_int_cmp is a general purpose function for
> int lists that can be reused elsewhere in the future. Whereas
> cmp_list_len_contents_asc is very specific to this case so I kept it local.

Of course. I got the intention and I have noted my opinion.
>
> I'm happy to change it around if that's what consensus wants.

As before, I will not hold a too strong opinion.

>
> > Overall :+1: from me.
>
> Thanks for looking at it!
>
> > I will be bumping to 'Ready for Committer' unless objections.
>
> In that case, here is another patch that fixes a typo in the docs
> mentioned privately to me by Erik. The typo (and a gratuitous rebase)
> is the only change to what you just reviewed.

Thank you. The typo was indistiguishable to me too.

My :+1: stands for version 3 of the patch. Updating status in the
commitfest to reflect that.

//Georgios -- https://www.vmware.com

>
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Vik Fearing

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2021-03-03 16:58:08 Step 8 does not perform as documented
Previous Message Vik Fearing 2021-03-02 16:51:52 Re: GROUP BY DISTINCT

Browse pgsql-hackers by date

  From Date Subject
Next Message Joel Jacobson 2021-03-02 19:34:36 Re: [PATCH] Support empty ranges with bounds information
Previous Message Joel Jacobson 2021-03-02 19:20:59 Re: [PATCH] Support empty ranges with bounds information