Re: ANSI SQL proposal: SELECT DISTINCT ON (... ORDER BY ...) and UNION DISTINCT ON (... ORDER BY ...) - Mailing list pgsql-hackers

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