Postgres Pro
Downloads
Home   >   mailing lists

Re: [despammed] "NOT NULL" - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: [despammed] "NOT NULL"
Date
Msg-id 20050524050814.GA22739@webserv.wug-glas.de
Whole thread Raw
In response to "NOT NULL"  (tövis <tovises@freemail.hu>)
List pgsql-novice
Tree view 
am  23.05.2005, um 23:32:14 +0200 mailte tövis folgendes:
> aid;num;name30
> "374";"0";"2181                          "
> "371";"0";"2178                          "
> ..
>
> Is this a NULL or not? May be the method is not precise enough?

No. NULL != 0. NULL is empty, and you cant calculate with NULL.

test=# select NULL+5;
 ?column?
----------

(1 Zeile)

test=# select 0+5;
 ?column?
----------
        5
(1 Zeile)


Regards, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-novice by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: [despammed] more "NOT NULL"
Next
From: Jaime Casanova
Date:
Subject: Re: "NOT NULL"