public.get_splittedstrings_fn

-- FUNCTION: public.get_splittedstrings_fn(character varying, character varying)

-- DROP FUNCTION public.get_splittedstrings_fn(character varying, character varying);

CREATE OR REPLACE FUNCTION public.get_splittedstrings_fn(
	psource character varying,
	psplitter character varying)
    RETURNS TABLE(data_n integer, data_item character varying)
    LANGUAGE 'plpgsql'
    COST 100
    VOLATILE PARALLEL UNSAFE
    ROWS 1000

AS $BODY$
BEGIN
    DECLARE
        p integer;
        l integer;
        value varchar(1000);
begin
     l = LEN(pSplitter);

    WHILE LEN(pSource) > 0 loop
        select p =strpos(pSource, pSplitter);
        if p = 0 then
         select p = LEN(pSource) + l;
		 end if;
        value = LEFT(pSource, p-1);
        insert into data select value;
        pSource = SUBSTRING(pSource, p+l, LEN(pSource));
    END loop;
    return;
	end;
END;
$BODY$;

ALTER FUNCTION public.get_splittedstrings_fn(character varying, character varying)
    OWNER TO postgres;