postgres=# select regexp_split_to_table('-1%0.76%1%2',E'\\%')::numeric( 2 , 1 ) as id, 
regexp_split_to_table('first%%%last',E'\\%')::varchar( 4 ) as text, 
regexp_split_to_table('12.12.2010 12:45:23%13.12.2010 13:02:34%14.12.2010 12:59:04%15.12.2010
 13:02:45',E'\\%')::timestamp as time;
  id  | text |        time
------+------+---------------------
 - 1 . 0  | firs |  2010 - 12 - 12   12 : 45 : 23 
   0 . 8  |      |  2010 - 12 - 13   13 : 02 : 34 
   1 . 0  |      |  2010 - 12 - 14   12 : 59 : 04 
   2 . 0  | last |  2010 - 12 - 15   13 : 02 : 45 
( 4  rows)

-- DROP FUNCTION add_testtable(text, text, text);

CREATE OR REPLACE FUNCTION add_testtable(IN c_id text, IN c_text text, IN c_time text, OUT result text)
  RETURNS text AS
$BODY$declare s char;
begin
    s=chr( 13 );
    result='';
    begin
        insert into testtable ("id","text","time")
        select regexp_split_to_table($ 1 ,E'\\'||s)::numeric( 2 , 1 ), 
        regexp_split_to_table($ 2 ,E'\\'||s)::varchar( 4 ), 
        regexp_split_to_table($ 3 ,E'\\'||s)::timestamp;
    exception
        when others then
            result = SQLSTATE || '. ' || SQLERRM ;
    end;
    return;
end;$BODY$
  LANGUAGE plpgsql VOLATILE
  COST  100 ;

postgres=# select ' '::date;
ERROR:  invalid input syntax for type date: " "
СТРОКА  1 :select ' '::date;
                ^