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
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 |