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 simple query:
>
> For example I
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
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
>
> Met vriendelijke groet,
>
> Paul Dam
> Informatieanalist
>
>
>
>
> Amyyon
> Bijsterhuizen 11.58
> 6546
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'
NULL values?
Met vriendelijke groet,
Paul Dam
Informatieanalist
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: pg
