converting type and function in postgresql ?

From: "Amar Dhole" <adhole(at)tibco(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: converting type and function in postgresql ?
Date: 2010-12-21 11:33:11
Message-ID: B290BFEC59278744B17A7A3CB14307E9037613B8@NA-PA-VBE04.na.tibco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Viktor Bojović 2010-12-21 11:34:19 data import
Previous Message Trinath Somanchi 2010-12-21 11:06:12 Re: linux. ossp-uuid