Shane Ambler wrote:
Lutz Steinborn wrote:
Jepp, thats it.
I've supposed this but can't believe it. So NULL is something out of
this
dimension :-)
NULL refers to an unknown value - it cannot be said to equal or not
equal anything other than NULL ...
Not exactly. Null does not equal null.
--- On Fri, 11/28/08, Lutz Steinborn <[EMAIL PROTECTED]> wrote:
> From: Lutz Steinborn <[EMAIL PROTECTED]>
> Subject: [SQL] wired behaviour
> To: pgsql-sql@postgresql.org
> Date: Friday, November 28, 2008, 1:51 PM
> Hello,
>
> I have an problem understanding a
Lutz Steinborn wrote:
Hello Paul,
thanks for the quick answer.
NULL values?
Jepp, thats it.
I've supposed this but can't believe it. So NULL is something out of this
dimension :-)
Kindly regards
Lutz
NULL refers to an unknown value - it cannot be said to equal or not
equal anything other
On fös, 2008-11-28 at 15:22 +0100, Lutz Steinborn wrote:
> Hello Paul,
>
> thanks for the quick answer.
>
> > NULL values?
> Jepp, thats it.
> I've supposed this but can't believe it. So NULL is something out of this
> dimension :-)
Yes, that is one way of putting it.
A more useful way to look
t;
>
> Amyyon
> Bijsterhuizen 11.58
> 6546 AS Nijmegen
> 050 - 311 5686
> www.amyyon.nl
> -Oorspronkelijk bericht-
> Van: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Namens Lutz Steinborn
> Verzonden: vrijdag 28 november 2008 14:52
> Aan: pgsql-sql@postgr
On Nov 28, 2008, at 8:51 AM, Lutz Steinborn wrote:
Hello,
I have an problem understanding a simple query:
For example I have the following:
select count(*) from foo;
gives me 1000
select count(*) from foo where bar = 'Mr Spock';
gives me 5
select count(*) from foo where NOT bar = 'Mr Spock'
: pgsql-sql@postgresql.org
Onderwerp: [SQL] wired behaviour
Hello,
I have an problem understanding a simple query:
For example I have the following:
select count(*) from foo;
gives me 1000
select count(*) from foo where bar = 'Mr Spock';
gives me 5
select count(*) from foo where NOT
Hello,
I have an problem understanding a simple query:
For example I have the following:
select count(*) from foo;
gives me 1000
select count(*) from foo where bar = 'Mr Spock';
gives me 5
select count(*) from foo where NOT bar = 'Mr Spock';
gives me 857
Why I'm not getting 955 for the last qu
