Dear Yousefredha,

Yes it is possible to make SQL functions with parameters: here are some examples :

-simple function

CREATE OR REPLACE FUNCTION addition(a NUMERIC, b NUMERIC) 

RETURNS NUMERIC AS $$

BEGIN

    RETURN a + b;

END; 

$$ LANGUAGE plpgsql;

SELECT addition(2,5);

-manipulate data from odoo

CREATE OR REPLACE FUNCTION findPartnerName (partner_id INTEGER) RETURNS TEXT AS $$
SELECT name FROM res_partner
WHERE id = partner_id;
$$ LANGUAGE SQL;

SELECT findPartnerName(5);

Don't hesitate to ask any more questions.

Sincerely,

Yvan.