empty

Поиск
Список
Период
Сортировка
Искать

empty

От:
ryanne cruz <ryanne.cruz@up.edu.ph>
Дата:
 
hi list. 
 
i have a column which has some rows int it that has no data. how do i select 
them? 
 
thanks! 

Re: empty

От:
Andrew McMillan <andrew@catalyst.net.nz>
Дата:
On Wed, 2003-01-22 at 20:14, ryanne cruz wrote:
>  hi list. 
>  
> i have a column which has some rows int it that has no data. how do i select 
> them? 

If the column has NULL values:

SELECT column FROM table WHERE other_column IS NULL;

or (if the column has blank values):

SELECT column FROM table WHERE other_column = '';


Also, may I recommend:

http://www.postgresql.org/idocs/index.php?user.html


Regards,
					Andrew.
-- 
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/         PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201     MOB: +64(21)635-694    OFFICE: +64(4)499-2267
           Survey for nothing with http://survey.net.nz/ 
---------------------------------------------------------------------

Re: empty

От:
ryanne cruz <ryanne.cruz@up.edu.ph>
Дата:
Thanks again.  
 
Quoting Andrew McMillan : 
 
> On Wed, 2003-01-22 at 20:14, ryanne cruz wrote: 
> >  hi list.  
> >   
> > i have a column which has some rows int it that has no data. how do i 
> select  
> > them?  
>  
> If the column has NULL values: 
>  
> SELECT column FROM table WHERE other_column IS NULL; 
>  
> or (if the column has blank values): 
>  
> SELECT column FROM table WHERE other_column = ''; 
>  
>  
> Also, may I recommend: 
>  
> http://www.postgresql.org/idocs/index.php?user.html 
>  
>  
> Regards, 
> 					Andrew. 
> --  
> --------------------------------------------------------------------- 
> Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St,  Wellington 
> WEB: http://catalyst.net.nz/         PHYS: Level 2, 150-154 Willis St 
> DDI: +64(4)916-7201     MOB: +64(21)635-694    OFFICE: +64(4)499-2267 
>            Survey for nothing with http://survey.net.nz/  
> --------------------------------------------------------------------- 
>  
>  
> ---------------------------(end of broadcast)--------------------------- 
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org 
>  
 
 
FAQ