Re: Missing numbers

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."