gistfile1.sql

CREATE OR REPLACE FUNCTION sexoVendedorPorModelo(varchar(64))
RETURNS character(1) AS
$$
DECLARE 
	sex character(1);
	quantity int := 0;	
	c record;
BEGIN
	FOR c IN
		SELECT funcionario.sexo AS sexo, count(funcionario.sexo) AS quantity_sold
		FROM venda 
			INNER JOIN carro ON venda.id_carro = carro.id
			INNER JOIN funcionario ON venda.cpf_vendedor = funcionario.cpf
		WHERE carro.modelo = $1
		GROUP BY funcionario.sexo
	LOOP
		IF c.quantity_sold > quantity THEN
			quantity := c.quantity_sold;
			sex := c.sexo;
		END IF;
	END LOOP;

	RETURN sex;
END
$$ LANGUAGE plpgsql;