Re: postgres cust types

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