-- Return the name of a certain soundfile
CREATE or REPLACE FUNCTION  soundfile_name(integer, integer) RETURNS varchar AS
'select replace(name, ''.gsm'', '''') as result from soundfile where company = $1 and id = $2;
' LANGUAGE SQL;

