| From: | Thomas Kellerer <shammat(at)gmx(dot)net> |
|---|---|
| To: | pgsql-sql(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Partition by outer join |
| Date: | 2021-08-24 16:45:17 |
| Message-ID: | 5deed05d-fb97-9d80-853d-ca083589f5ca@gmx.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
David G. Johnston schrieb am 24.08.2021 um 18:09:
>> 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".
I think the partitioned outer join generates missing values on the fly
based on the "partition" information. So I think it's a bit different
than "just" a full outer join.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | aditya desai | 2021-08-26 03:37:13 | Re: Partition by outer join |
| Previous Message | David G. Johnston | 2021-08-24 16:09:26 | Re: Partition by outer join |