Skip site navigation (1) Skip section navigation (2)

Re: "NOT NULL"

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: tövis <tovises(at)freemail(dot)hu>
Cc: pgsql novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: "NOT NULL"
Date: 2005-05-24 05:28:06
Message-ID: c2d9e70e05052322285c8c7dc3@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 5/23/05, tövis <tovises(at)freemail(dot)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 ;)

In response to

Responses

pgsql-novice by date

Next:From: tövisDate: 2005-05-24 06:38:53
Subject: Re: "NOT NULL"
Previous:From: Andreas KretschmerDate: 2005-05-24 05:09:35
Subject: Re: [despammed] more "NOT NULL"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group