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

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.