about NULL

From: zhangyue <postgresql(at)db(dot)pku(dot)edu(dot)cn>
To: pgsql-hackers(at)postgresql(dot)org <pgsql-hackers(at)postgresql(dot)org>
Subject: about NULL
Date: 2003-05-21 08:10:23
Message-ID: 200305211548390.SM01104@zhangyue
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi,
How can I get the tuples one of whose attributes is NULL?
For example,
First, create table tb(id int,name text);
Then insert into tb values(1);
insert into tb values(2,'Rose');
I want to select the tuples whose attribute name= NULL,
How to write the sql ?
Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-05-21 08:43:51 Re: SELECT DISTINCT ON bug?
Previous Message Jean-Christian Imbeault 2003-05-21 08:08:33 Re: SELECT DISTINCT ON bug?

Browse pgsql-hackers by date

  From Date Subject
Next Message Shridhar Daithankar 2003-05-21 08:46:47 Re: [HACKERS] about NULL
Previous Message Tom Lane 2003-05-21 04:25:50 Re: Free Space?