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-3TpH7b0h8xHSHjALqBgJBeUTwVjFwVntcZpVXHOxuA@mail.gmail.com
>
> thanks in advance,
--
Adrian Klaver
adrian.klaver@aklaver.com