PostgreSQL - procedimiento almacenado que no devuelve nada

CREATE PROCEDURE MUESTRA_CLIENTE(ID_CLIENTE INT)

LANGUAGE SQL

AS $$

SELECT DISTINCT

res_partner.name as NOMBRE,

res_country.name as PAÍS ,

res_country_state.name as PROVINCIA

from res_partner,res_country,res_country_state

where res_partner.id=ID_CLIENTE and

res_partner.state_id=res_country.id and

res_partner.country_id=res_country_state.id

$$;