| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | Alexander Pyhalov <alp(at)rsu(dot)ru> |
| Cc: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: I don't understand something... |
| Date: | 2011-10-03 08:02:16 |
| Message-ID: | 20111003080216.GC4824@depesz.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Oct 03, 2011 at 11:48:45AM +0400, Alexander Pyhalov wrote:
> On 10/03/2011 11:19, Achilleas Mantzios wrote:
> >Alexander, that's a classic one,
> >rewrite your last query as :
> >
> >SELECT count(employee_id) from employees where employee_id not in
> > (select manager_id from employees WHERE manager_id IS NOT NULL);
> >
> >NULLS semantics are sometimes not so obvious.
>
> Thanks.
> It's confusing, that IN check works as expected, but NOT IN works
> this way...
If I might plug:
http://www.depesz.com/index.php/2008/08/13/nulls-vs-not-in/
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2011-10-03 08:11:55 | Re: [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe |
| Previous Message | Magnus Hagander | 2011-10-03 07:59:14 | Re: [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe |