converting type and function in postgresql ? - Mailing list pgsql-sql

From Amar Dhole
Subject converting type and function in postgresql ?
Date
Msg-id B290BFEC59278744B17A7A3CB14307E9037613B8@NA-PA-VBE04.na.tibco.com
Whole thread
Responses Re: converting type and function in postgresql ?
List pgsql-sql

Hi,

 

I am new to postgesql.

 

I have oracle type and function, which I needs to converting it into postgresql .

 

I am using postgresql 9.x

 

Type :

CREATE OR REPLACE

TYPE INST

AS TABLE OF VARCHAR2(255)

 

How this type can be written in postgresql ??

 

 

Oracle Function:

 

CREATE OR REPLACE function in_list ( p_string in varchar2 ) return INST

    as

        l_string        long default p_string || ',';

        l_data          INST := INST();

        n               number;

    begin

      loop

          exit when l_string is null;

          n := instr( l_string, ',' );

         l_data.extend;

         l_data(l_data.count) := ltrim( rtrim( substr( l_string, 1, n-1 ) ) );

         l_string := substr( l_string, n+1 );

    end loop;

 

    return l_data;

  end;

 

how this function can be rewritten in postgresql ?

 

your help will help me a lot.

 

Thanks
Amar

pgsql-sql by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: data import
Next
From: Trinath Somanchi
Date:
Subject: Re: converting type and function in postgresql ?