Em 28 de junho de 2011 20:15, Dickson S. Guedes <[email protected]>escreveu:
> > Uma outra seria: > > SELECT i > FROM generate_series(1,(SELECT max(v) FROM foo)) AS i > LEFT JOIN foo ON (v = i) > WHERE v IS NULL; > > Ou ainda: SELECT i FROM generate_series(1,(SELECT max(v) FROM foo)) AS i WHERE NOT EXISTS (SELECT 1 FROM foo WHERE v = i) ;-) -- Fabrízio de Royes Mello >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
