How to select rows with values set to NULL

From: "Tille, Andreas" <TilleA(at)rki(dot)de>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: How to select rows with values set to NULL
Date: 2002-05-23 08:00:05
Message-ID: Pine.LNX.4.44.0205230957190.8932-100000@wr-linux02.rki.ivbb.bund.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

InfluenzaWeb=# create table test (
InfluenzaWeb(# id int,
InfluenzaWeb(# txt varchar(17) default NULL);
CREATE
InfluenzaWeb=# insert into test values( 1 );
INSERT 553756 1
InfluenzaWeb=# select * from test;
id | txt
----+-----
1 |
(1 row)

InfluenzaWeb=# select * from test where txt = NULL;
id | txt
----+-----
(0 rows)

InfluenzaWeb=# insert into test values(2,'text');
INSERT 553757 1
InfluenzaWeb=# select * from test where txt like '%';
id | txt
----+------
2 | text
(1 row)

InfluenzaWeb=# select * from test where not txt like '%';
id | txt
----+-----
(0 rows)

So how to get all rows which txt has the value NULL?

Kind regards

Andreas.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tille, Andreas 2002-05-23 08:11:33 Substring from end of string
Previous Message Stephan Szabo 2002-05-23 04:02:59 Re: Named constraints