From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Diferences between IN and EXISTS? |
Date: | 2013-02-03 05:06:29 |
Message-ID: | CAFj8pRBn-WYwR79Barf4TBjpa-AP5=sz+HarD06ikRpidH7EcQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
2013/2/3 Edson Richter <edsonrichter(at)hotmail(dot)com>:
> Hi!
>
> Assumptions: PostgreSQL 9.2.2, Win64, already run vacumm full freeze
> analyze. No problems in the database. I know there are 1247 records to be
> found.
> Why does these queries return different results:
>
>
> select count(*) from parcela
> where id not in (select parcela_id from cadastroservicoparcela);
>
> count
> --------
> 0
>
>
> select count(*) from parcela
> where not exists (select 1 from cadastroservicoparcela where parcela_id =
> parcela.id);
>
> count
> --------
> 1247
>
>
> I can't figure out, I did expect that the first one returns exactly same
> result!
> Could null values in cadastroservicoparcela.parcela_id affect the first
> query?
>
sure
Regards
Pavel
>
> Thanks,
>
> Edson
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Edson Richter | 2013-02-03 05:31:47 | Re: Diferences between IN and EXISTS? |
Previous Message | Jasen Betts | 2013-02-03 04:26:34 | Re: Is there a way to add a detail message in a warning with pl/Python? |