Re: Partition by outer join

Hi,
Can someone help? Thanks in advance.

Regards,
Aditya.

On Mon, Aug 23, 2021 at 9:22 PM aditya desai <admad123(at)gmail(dot)com> wrote:

> Hi,
> 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.
>
> Select csa_mast.cconsol,
>
> csa_mast.tics_code,
>
> csa_mast.csa_id,
>
> csa_mast.csa_type,
>
> csa_mast.ccy,
>
> csa_mast.collateral_curve_id,
>
> csa_mast.check_non_std_flags
>
> from dummy
>
> left outer join csa_mast partition by (csa_mast.cconsol)
>
> on ( (did = 1 and (csa_id is null or csa_mast.csa_type = ‘LEG’))
>
> or
>
> (d.id = 2 and csa_mast.csa_type = ‘REG’)
>
> )
>
> Where d.id = 1
>
> Or (d.id = 2 and csa_mast.csa_type = ‘REG’)
>
>
> Regards,
>
> Aditya.
>