Re: BUG #4816: NOT IN clause, doesn't work

jose soares escribió:
> The following bug has been logged online:
>
> Bug reference: 4816
> Logged by: jose soares
> Email address: jose(dot)saores(at)sferacarta(dot)com
> PostgreSQL version: 8.3.5
> Operating system: x86_64-pc-linux-gnu, compiled by GCC gcc-4.3.real
> (Debian 4.3.2-1) 4.3.2
> Description: NOT IN clause, doesn't work
> Details:
>
> Hello all,
>
> I'm trying a NOT IN clause, but seems it doesn't work. Please take a look:
>
>
> mydb=# select distinct id from psop where id_ua = 72492;
> id
> -------
> 56844
> 67953
> 67955
> (3 rows)
>
> mydb=# select distinct id_sop from scad where id_ua = 72492;
> ----------------
> 56844
> 67953
>
> (3 rows)
>
> mydb=# select distinct id from psop where id_ua = 72492 and id not in
> (select distinct id_sop from scad where id_ua = 72492);
> id
> ----
> (0 rows)
>
> mydb=# select distinct id from psop where id_ua = 72492 and id not in
> (56844,67953);
> id
> -------
> 67955
> (1 row)
>
>
> What's wrong with those selects?
>
> j
>
>
Hola, el problema me parece que lo introduce algun nulo en el valor de id.
como no podemos ver las estructuras y el juego de datos , estamos
limitados a suposiciones como la que te envio

Saludos Fernando