Re: Partition by outer join

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: aditya desai <admad123(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: Partition by outer join
Date: 2021-08-24 06:32:12
Message-ID: 20210824063212.GA8911@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Kellerer 2021-08-24 06:39:26 Re: Partition by outer join
Previous Message aditya desai 2021-08-24 03:58:15 Re: Partition by outer join