Skip site navigation (1) Skip section navigation (2)

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

From: Rodriguez Fernando <rodriguez(at)ort(dot)edu(dot)uy>
To: jose soares <jose(dot)saores(at)sferacarta(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4816: NOT IN clause, doesn't work
Date: 2009-05-20 11:40:07
Message-ID: 4A13EC17.40602@ort.edu.uy (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

pgsql-bugs by date

Next:From: hubert depesz lubaczewskiDate: 2009-05-20 12:01:08
Subject: Re: BUG #4816: NOT IN clause, doesn't work
Previous:From: jose soaresDate: 2009-05-20 09:37:56
Subject: BUG #4816: NOT IN clause, doesn't work

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group