Re: [HACKERS] about NULL

SELECT * FROM tb WHERE name IS NULL;

And I think it should have been on the SQL list, myself...

Shridhar Daithankar wrote:

On 21 May 2003 at 16:10, zhangyue wrote:
 

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 ?   

select columns from table where attribute is null;

This should have been on postgresql-general, not on hackers..

HTH

ByeShridhar

--
Fourth Law of Applied Terror:	The night before the English History mid-term, 
your Biology	instructor will assign 200 pages on planaria.Corollary:	Every 
instructor assumes that you have nothing else to do except	study for that 
instructor's course.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html