On 02/14/2015 08:58 AM, Ramesh T wrote:
exactly what I am trying convert oracle to postgres , following 1)first i am creating type in oracle CREATE TYPE suborder_list AS (suborder_id int);2)second creating table type in oracle create or replace type suborder_list_table as table of suborder_list; 3)i am using above 1 and 2 created types oracle function create or replace FUNCTION check(id int) RETURNS suborder_list_table is BEGIN v_ret :=suborder_list_table(); FOR VAR_CUR1 IN cur1 LOOP invcount:=0; SELECT COUNT(id) INTO invcount FROM detail iv WHERE iv.id <http://iv.id> = id AND cd IN (SELECT cd FROM detail) IF (invcount>0) THEN v_ret.extend; v_ret(v_ret.count) := suborder_list(VAR_CUR1.id); END IF; END LOOP; RETURN v_ret; here cur1 is cursor above 1 and 2 used in 3'rd step of oracle function,now i need to convert oracle function into postgres format any help..?
See my previous responses to this question: http://www.postgresql.org/message-id/CAK8Zd=t-3tph7b0h8xhshjalqbgjbeutwvjfwvntczpvxho...@mail.gmail.com
thanks in advance,
-- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
