Re: ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...)

Here is a patch set implementing this

On Sat, Aug 1, 2026 at 3:08 PM Hannu Krosing <hannuk(at)google(dot)com> wrote:

> Hi Vik
>
> Finally had time to put this SQL Standard Propoasl together.
>
> Please take a quick look and tell me what is missing or wrong and what
> the next steps should be.
>
> For example, should I mention somewhere that PostgreSQL supports a
> partial version of the SELECT DISTINCT ON () ?
>
> Regarding PGQ in PostgreSQL, this should allow a plain SQL target for
> arbitrary length graph queries and at least some types of path finding
> queries.
>
> I hope to have some working PoC code for PostgreSQL within the next
> few days so I can share actual working versions of both sample
> recursive graph queries and the "overlay of read-only table" queries I
> talked to you about.
>
> -----
> Hannu
>