Re: [SQL] split function for pl/pgsql

2002-10-02 Thread Joe Conway
Frederic Logier wrote: > Great ! have you some example for call a pl/perl function from a > pl/pgsql function ? I don't use PL/Perl, but I think you should be able to do: SELECT INTO var my_plperl_func(text_to_split); from within your PL/pgSQL function. > And could i use an int array in pl/pg

Re: [SQL] split function for pl/pgsql

2002-10-02 Thread Frederic Logier
Le mer 02/10/2002 à 17:44, Joe Conway a écrit : > There is no split function built in to PostgreSQL currently. You could write > it yourself in PL/Perl and use it in the PL/pgSQL function. Great ! have you some example for call a pl/perl function from a pl/pgsql function ? And could i use an int

Re: [SQL] split function for pl/pgsql

2002-10-02 Thread Joe Conway
Frederic Logier wrote: > hi, > > i'm looking for a split function, like perl or php. > I need doing a pl/pgsql function with a split return an array. > I must do some loop with this array for mass inserting. > > I think of doing it with pl / perl but I need to do insert and I don't > find exampl

[SQL] split function for pl/pgsql

2002-10-02 Thread Frederic Logier
hi, i'm looking for a split function, like perl or php. I need doing a pl/pgsql function with a split return an array. I must do some loop with this array for mass inserting. I think of doing it with pl / perl but I need to do insert and I don't find example with pl / perl and sql. Here my func