Re: consulta sql

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: Whole Thread | Raw Message | 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

Browse pgsql-es-ayuda by date

  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