On Mon, Aug 23, 2021 at 11:32 PM hubert depesz lubaczewski <depesz@depesz.com> wrote:
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?
Yeah, posting with the hope that someone with cross-DB knowledge might be available to chime in makes sense. But absent any response one should then try and frame the problem in such a way as to not require knowledge beyond what PostgreSQL can do.
But a simple paragraph describing what the query is doing would be an ok starting point - though as always the more detailed and self-contained the problem statement the better.