Postgres Pro
Downloads
Home   >   mailing lists

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

From hubert depesz lubaczewski
Subject Re: Partition by outer join
Date
Msg-id 20210824063212.GA8911@depesz.com
Whole thread Raw
In response to Partition by outer join  (aditya desai <admad123@gmail.com>)
Responses Re: Partition by outer join  (aditya desai <admad123@gmail.com>)
Re: Partition by outer join  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-sql
Tree view 
On Mon, Aug 23, 2021 at 09:22:47PM +0530, aditya desai wrote:
> While trying to migrate Oracle to Postgres wera stuck with PARTITION BY
> OUTER JOIN. Can someone help rewriting or helping with Postgres
> equivalent of below query? Thanks in advance.

It would make MUCH more sense to show us data and expected output.
Why do you assume Pg dbas know and understand intricacies of Oracle?

depesz

pgsql-sql by date:

Previous
From: aditya desai
Date:
Subject: Re: Partition by outer join
Next
From: Thomas Kellerer
Date:
Subject: Re: Partition by outer join