| From: | Andreas Kretschmer <akretschmer(at)despammed(dot)com> |
|---|---|
| To: | pgsql novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: [despammed] "NOT NULL" |
| Date: | 2005-05-24 05:08:14 |
| Message-ID: | 20050524050814.GA22739@webserv.wug-glas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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 ===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2005-05-24 05:09:35 | Re: [despammed] more "NOT NULL" |
| Previous Message | Jaime Casanova | 2005-05-24 01:02:13 | Re: "NOT NULL" field |