Re: [GENERAL] Postgresql string parsing

2006-04-03 Thread Jim Nasby
On Mar 29, 2006, at 12:19 PM, Tony Caduto wrote: [EMAIL PROTECTED] wrote: Hi Folks, I'm looking for the fatest way to parse string in a postgresql function and insert each parsed chunk in a table. Something like that: You might be able to use the |string_to_array function which | splits

Re: [GENERAL] Postgresql string parsing

2006-03-29 Thread Tony Caduto
[EMAIL PROTECTED] wrote: Hi Folks, I'm looking for the fatest way to parse string in a postgresql function and insert each parsed chunk in a table. Something like that: You might be able to use the |string_to_array function which |splits a string into array elements using the provided delim

[GENERAL] Postgresql string parsing

2006-03-29 Thread ycrux
Hi Folks, I'm looking for the fatest way to parse string in a postgresql function and insert each parsed chunk in a table. Something like that: CREATE FUNCTION parse_and_insert(text) RETURNS integer AS ' DECLARE my_string ALIAS FOR $1; -- empty string, do nothing IF my_stri