2012/8/18 Ramiro Pamponet <[email protected]> > Fabrizio, > > Sua solução atende 99% as minhas necessidades. Fiz umas alterações. > > select nome, aniversario from clientes > where extract(MONTH from aniversario) >= extract(MONTH from now()) > order by extract(MONTH from aniversario), extract(DAY from aniversario) > >
Tente assim: SELECT nome, aniversario FROM clientes WHERE extract(MONTH from aniversario) > extract(MONTH from now()) OR (extract(MONTH from aniversario) = extract(MONTH from now()) AND extract(DAY from aniversario) >= extract(DAY from now())) ORDER BY extract(MONTH from aniversario), extract(DAY from aniversario) Atenciosamente, -- Matheus de Oliveira
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
