On Tue, Aug 24, 2021 at 9:02 AM Steve Midgley <science@misuse.org> wrote:
From that stackexchange post, it appears that partition in Oracle is similar to cross joins in Postgres -- where elements are included in the result set as a matrix, whether they exist in the source data or not (so sparsely populated values are included as nulls when they exist in either of the two columns that are cross joined).
What you describe sounds like it would be an SQL Standard (I think) "FULL OUTER JOIN".