From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
---|---|
To: | zhangyue <postgresql(at)db(dot)pku(dot)edu(dot)cn> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [HACKERS] about NULL |
Date: | 2003-05-21 08:46:47 |
Message-ID: | 3ECB8A4F.11632.562181D@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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
Bye
Shridhar
--
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2003-05-21 08:49:10 | Re: about NULL |
Previous Message | Martijn van Oosterhout | 2003-05-21 08:43:51 | Re: SELECT DISTINCT ON bug? |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2003-05-21 08:49:10 | Re: about NULL |
Previous Message | zhangyue | 2003-05-21 08:10:23 | about NULL |