Postgresql string parsing

From: ycrux(at)club-internet(dot)fr
To: mike(at)fuhr(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Postgresql string parsing
Date: 2006-03-29 16:51:23
Message-ID: mnet1.1143651083.25367.ycrux@club-internet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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_string IS NULL THEN
-- split my_string at each new line char '\n', '\r\n' or '\r'

-- loop for each founded chunk, and simply insert it
INSERT INTO tableX (data) VALUES (chunk);

return 1;
END IF;

-- empty string, do nothing
return 0;

END;
' LANGUAGE 'plpgsql';

My be there is exists complety different and fasted method?

Thanks in advance guys

/Youn

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2006-03-29 17:19:34 Re: Postgresql string parsing
Previous Message Bob Pawley 2006-03-29 16:50:40 Re: Connecting