Re: Wrong query execution.

From: "Mike Mascari" <mascarm(at)mascari(dot)com>
To: <dev(at)archonet(dot)com>, "pginfo" <pginfo(at)t1(dot)unisoftbg(dot)com>
Cc: <dev(at)archonet(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Wrong query execution.
Date: 2003-01-15 17:47:20
Message-ID: 01ab01c2bcbe$271cc440$0102a8c0@mascari.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

----- Original Message -----
> > Hi Richard,
> > It is the case.
> > I have found records with NULL's !
> > Exist any docs where I can read more about interpreting of NOT IN ?
>
> There's an item on it in my Postgresql Notes (subqueries and NULLs),
> linked to from
>
> http://techdocs.postgresql.org
>
> You can also read more about it in Bruce's book (also available online
> from the above URL).
>
> Basically, any good relational database book should have a section of the
> meaning of nulls.

And why they shouldn't be allowed in a database. ;-)

Mike Mascari
mascarm(at)mascari(dot)com

>
> - Richard Huxton
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2003-01-15 18:19:47 Re: [SQL] sort by relevance
Previous Message Philip Hallstrom 2003-01-15 17:32:47 Re: postgres on a PDA