agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Thomas Kellerer <shammat@gmx.net>
To: pgsql-sql@lists.postgresql.org
Subject: Re: Partition by outer join
Date: Tue, 24 Aug 2021 18:45:17 +0200
Message-ID: <5deed05d-fb97-9d80-853d-ca083589f5ca@gmx.net> (raw)
In-Reply-To: <CAKFQuwaTxJsS_7pm0RjrEOZDXJS=HmVG5ZJq7Y-n=1k6Bon6Gg@mail.gmail.com>
References: <CAN0SRDEBQyzV2Ze0jN-rtA+SzpHSA9RP5=7hC1ASYpP-4pD5gQ@mail.gmail.com>
<20210824063212.GA8911@depesz.com>
<CAN0SRDGNULQKOyZ6gykyQsgtGyykbQ3XWWtBuQBRLFcXzo7-wQ@mail.gmail.com>
<CAJexoSJrP9KTo5Xno1-q+WOpHaO3ArGBkLh5UX7S683y1X83jw@mail.gmail.com>
<CAKFQuwaTxJsS_7pm0RjrEOZDXJS=HmVG5ZJq7Y-n=1k6Bon6Gg@mail.gmail.com>
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.
view thread (10+ messages) latest in thread
Message-ID: <5deed05d-fb97-9d80-853d-ca083589f5ca@gmx.net>
Permalink: ../5deed05d-fb97-9d80-853d-ca083589f5ca@gmx.net/
Also on: postgresql.org/message-id/5deed05d-fb97-9d80-853d-ca083589f5ca@gmx.net
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: shammat@gmx.net, pgsql-sql@lists.postgresql.org
Subject: Re: Partition by outer join
In-Reply-To: <5deed05d-fb97-9d80-853d-ca083589f5ca@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox