CREATE FUNCTION login2contract(varchar) RETURNS int4 AS 'select contract_id from profile where login = $1' LANGUAGE 'SQL'; CREATE FUNCTION time_minus_int(timestamp, integer) RETURNS timestamp AS 'select $1 - interval ($2) AS RESULT' LANGUAGE 'SQL';