Fala, Faabízio 2010/7/6 Fabrízio de Royes Mello <[email protected]>
> 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; > Bem lembrado, mas é costume de quem programa tudo em PL/pgSQL. > > > -- > 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 > > []s -- JotaComm http://jotacomm.wordpress.com
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
