Postgres Pro
Downloads
Home   >   mailing lists

Re: Partition by outer join - Mailing list pgsql-sql

From aditya desai
Subject Re: Partition by outer join
Date
Msg-id CAN0SRDGYGX7t6KbqF=ZsjpqPtnwfcWp7x0Db-gT6gQuZ9Z=tXg@mail.gmail.com
Whole thread Raw
In response to Re: Partition by outer join  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Tree view
Thanks David and Steve!! I will take a look into this. Having a hard time getting data over here. Apologies.

Regards,
AD.

On Tue, Aug 24, 2021 at 9:39 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
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".

David J.

pgsql-sql by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Partition by outer join
Next
From: arjun shetty
Date:
Subject: PostgreSQL performance GNU vs LLVM