Partition by outer join
| От | aditya desai |
|---|---|
| Тема | Partition by outer join |
| Дата | |
| Msg-id | CAN0SRDEBQyzV2Ze0jN-rtA+SzpHSA9RP5=7hC1ASYpP-4pD5gQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Partition by outer join
Re: Partition by outer join Re: Partition by outer join |
| Список | 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 по дате отправления: