Re: [GENERAL] Convert Oracle function to PostgreSQL

2009-04-11 Thread Jasen Betts
On 2009-04-06, SHARMILA JOTHIRAJAH wrote: > Hi, > I use this Oracle function(from AskTom - > http://asktom.oracle.com/pls/asktom/f?p=100:11:0P11_QUESTION_ID:210612357425) > > ops$tk...@dev8i> create or replace > function in_list( p_string in varchar2 ) return myTableType > How ca

Re: [GENERAL] Convert Oracle function to PostgreSQL

2009-04-07 Thread Albe Laurenz
SHARMILA JOTHIRAJAH wrote: > I use this Oracle function(from AskTom - > http://asktom.oracle.com/pls/asktom/f?p=100:11:0P11_QUESTION_ID:210612357425) > > > > > SQL> create or replace type myTableType as table > of varchar2 (255); > 2 / > > Type created. > > ops$tk...@dev8i>

[GENERAL] Convert Oracle function to PostgreSQL

2009-04-06 Thread SHARMILA JOTHIRAJAH
Hi, I use this Oracle function(from AskTom - http://asktom.oracle.com/pls/asktom/f?p=100:11:0P11_QUESTION_ID:210612357425) SQL> create or replace type myTableType as table of varchar2 (255); 2 / Type created. ops$tk...@dev8i> create or replace function in_list( p_str