From: | josue <josue(at)lamundial(dot)hn> |
---|---|
To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
Cc: | hf1122x(at)protecting(dot)net, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Missing numbers |
Date: | 2005-06-01 14:07:39 |
Message-ID: | 429DC12B.3030903@lamundial.hn |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Simon Riggs wrote:
>>
>>You could use something like that:
>>
>>SELECT g.num
>>FROM generate_series ((SELECT min(doc_numero) FROM bdocs),
>> (SELECT max(doc_numero) FROM bdocs)) AS g(num)
>>LEFT JOIN bdocs ON bdocs.doc_numero = g.num
>>WHERE bdocs.doc_numero IS NULL
>
>
> SELECT g.num
> FROM generate_series ((SELECT min(doc_numero) FROM bdocs),
> (SELECT max(doc_numero) FROM bdocs)) AS g(num)
> WHERE g.num NOT IN (select doc_numero
> from bdocs
> where doc_numero is not null)
>
> is more likely to return a correct answer, since
> bdocs.doc_numero will never equal g,num when it is also NULL
Yes, it worked pretty fine. Thanks.
--
Sinceramente,
Josué Maldonado.
... "Cultura es el paso que nos queda después de haber olvidado todo lo
aprendido."
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2005-06-01 14:20:37 | Re: Newby to DB |
Previous Message | Bruce Momjian | 2005-06-01 12:42:11 | Re: PostgreSQL release schedule |