Ou também...
CREATE OR REPLACE FUNCTION f_funcionario_afastado(INTEGER)
RETURNS boolean AS
$$
SELECT EXISTS (SELECT 1
FROM historico_ferias
WHERE codfuncionario=$1
AND current_date BETWEEN datagozoini AND datagozofim);
$$
LANGUAGE SQL;
--
Fabrízio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
