BEGIN;

CREATE or REPLACE FUNCTION  soundfile_name(integer, integer) RETURNS varchar AS
'select replace(name, ''.gsm'', '''') as result from soundfile where id = $2;
' LANGUAGE SQL;

CREATE or REPLACE FUNCTION  soundfile_name(integer) RETURNS varchar AS
'select replace(name, ''.gsm'', '''') as result from soundfile where id = $1;
' LANGUAGE SQL;

COMMIT;
