CREATE or replace FUNCTION mod_log.top_hits(text)
returns setof getpass_type AS
'

SELECT uri, client_ip FROM mod_log.apachelog WHERE uri like ''%'' || $1 || ''%''
' LANGUAGE 'sql';

-- create type getpass_type as
-- (
-- username character varying(30),
-- password character varying(30)
-- );