| From: | Gabriel Hermes Colina Zambra <hermeszambra(at)yahoo(dot)com> |
|---|---|
| To: | "Crispin T(dot)" <cris(dot)emis(at)gmail(dot)com>, Fernando Moreno <azazel(dot)7(at)gmail(dot)com> |
| Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: consulta sql |
| Date: | 2009-07-11 22:57:20 |
| Message-ID: | 647812.96070.qm@web63708.mail.re1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
A mi me resulta algo asi.
select id_ausente from
(select generate_series(100000,100360) as id_ausente)
as foo
where id_ausente not in (select id_cab from central.cabezales)
Espero te sirva.
____________________________________________________________________________________
¡Obtén la mejor experiencia en la web!
Descarga gratis el nuevo Internet Explorer 8.
http://downloads.yahoo.com/ieak8/?l=e1
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gunnar Wolf | 2009-07-12 01:49:51 | Re: seguridad |
| Previous Message | Jaime Casanova | 2009-07-11 20:22:01 | Re: Ordenar Columnas |