Partition by outer join - Mailing list pgsql-sql

From aditya desai
Subject Partition by outer join
Date
Msg-id CAN0SRDEBQyzV2Ze0jN-rtA+SzpHSA9RP5=7hC1ASYpP-4pD5gQ@mail.gmail.com
Whole thread Raw
Responses Re: Partition by outer join
Re: Partition by outer join
Re: Partition by outer join
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.

pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Backup Functions
Next
From: aditya desai
Date:
Subject: Re: Partition by outer join