From: | Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com> |
---|---|
To: | David Rowley <dgrowleyml(at)gmail(dot)com> |
Cc: | pghackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Questions regarding distinct operation implementation |
Date: | 2022-11-25 05:30:33 |
Message-ID: | 0dab98bc-52f5-848b-e17b-766c79502d94@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 25/11/22 02:14, David Rowley wrote:
> On Fri, 25 Nov 2022 at 06:57, Ankit Kumar Pandey <itsankitkp(at)gmail(dot)com> wrote:
>> Please let me know any opinions on this.
> I think if you're planning on working on this then step 1 would have
> to be checking the SQL standard to see which set of rows it asks
> implementations to consider for duplicate checks when deciding if the
> transition should be performed or not. Having not looked, I don't
> know if this is the entire partition or just the rows in the current
> frame.
>
> Depending on what you want, an alternative today would be to run a
> subquery to uniquify the rows the way you want and then do the window
> function stuff.
>
> David
Thanks David, these are excellent pointers, I will look into SQL
standard first and so on.
--
Regards,
Ankit Kumar Pandey
From | Date | Subject | |
---|---|---|---|
Next Message | vignesh C | 2022-11-25 06:17:59 | Re: Support logical replication of DDLs |
Previous Message | Michael Paquier | 2022-11-25 05:18:51 | Re: [PATCH] Add peer authentication TAP test |