On Tue, Aug 24, 2021 at 9:02 AM Steve Midgley <science(at)misuse(dot)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".
David J.