Re: "NOT NULL" - Mailing list pgsql-novice

From tövis
Subject Re: "NOT NULL"
Date
Msg-id 002601c5602b$408b2c10$3401a8c0@mainxp
Whole thread Raw
In response to "NOT NULL"  (tövis <tovises@freemail.hu>)
Responses Re: "NOT NULL"
List pgsql-novice
OK
How to prevent insert/update rows with NULL = 0 values?
How to modify table or server change NULL = 0 values to fields DEFAULT
values, if is it given?
Regards
    Tövis

----- Original Message -----
From: "Jaime Casanova" <systemguards@gmail.com>
To: "tövis" <tovises@freemail.hu>
Cc: "pgsql novice" <pgsql-novice@postgresql.org>
Sent: Tuesday, May 24, 2005 7:28 AM
Subject: Re: [NOVICE] "NOT NULL"


On 5/23/05, tövis <tovises@freemail.hu> wrote:
> Thanks Jaime!
> Using pgAdmin III selected all rows:
> SELECT aid,num,name30 FROM nod ORDER BY num;
>
> First rows from result in a CSV file:
>
> aid;num;name30
> "374";"0";"2181                          "
> "371";"0";"2178                          "
> ...
>
> Is this a NULL or not? May be the method is not precise enough?
>
>
The better way you can prove that is:
SELECT aid,num,name30 FROM nod
WHERE num IS NULL ORDER BY num;

like Andreas said NULL is not 0, NULL is "unknown".

BTW, do the reply in this thread, that will do searches in
archives.postgresql.org easier.

--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings


pgsql-novice by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: "NOT NULL"
Next
From: Bendik Rognlien Johansen
Date:
Subject: Re: Help with prepared statement