Manu T, 07.11.2011 08:18:
I am using this query in the procedure and i error is throwing as mentioned
below.and i want to convert the same oracle query into Postgresql.
ERROR-->
*ERROR: syntax error at or near "OVER"
LINE 1: ...heme_id,d.value, d.dr_cr_flg , d.rule_id , RANK() OVER (part...
^
select d1.scheme_id,d1.value , d1.dr_cr_flg
INTO po_appl_scheme,po_scheme_val, po_dr_cr_flag
from ( select d.scheme_id,d.value, d.dr_cr_flg , d.rule_id ,
dense_rank() over (partition by d.rule_id order by
to_number(d.value) desc
