pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
empty
3+ messages / 2 participants
[nested] [flat]

* empty
@ 2003-01-22 07:14 ryanne cruz <ryanne.cruz@up.edu.ph>
  2003-01-22 07:36 ` Re: empty Andrew McMillan <andrew@catalyst.net.nz>
  0 siblings, 1 reply; 3+ messages in thread

From: ryanne cruz @ 2003-01-22 07:14 UTC (permalink / raw)
  To: pgsql-php

 
hi list. 
 
i have a column which has some rows int it that has no data. how do i select 
them? 
 
thanks! 



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: empty
  2003-01-22 07:14 empty ryanne cruz <ryanne.cruz@up.edu.ph>
@ 2003-01-22 07:36 ` Andrew McMillan <andrew@catalyst.net.nz>
  2003-01-22 07:57   ` Re: empty ryanne cruz <ryanne.cruz@up.edu.ph>
  0 siblings, 1 reply; 3+ messages in thread

From: Andrew McMillan @ 2003-01-22 07:36 UTC (permalink / raw)
  To: ryanne cruz <ryanne.cruz@up.edu.ph>; +Cc: pgsql-php

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/ 
---------------------------------------------------------------------




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: empty
  2003-01-22 07:14 empty ryanne cruz <ryanne.cruz@up.edu.ph>
  2003-01-22 07:36 ` Re: empty Andrew McMillan <andrew@catalyst.net.nz>
@ 2003-01-22 07:57   ` ryanne cruz <ryanne.cruz@up.edu.ph>
  0 siblings, 0 replies; 3+ messages in thread

From: ryanne cruz @ 2003-01-22 07:57 UTC (permalink / raw)
  To: pgsql-php@postgresql.org, Andrew McMillan <andrew@catalyst.net.nz>

Thanks again.  
 
Quoting 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/  
> --------------------------------------------------------------------- 
>  
>  
> ---------------------------(end of broadcast)--------------------------- 
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org 
>  
 
 



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2003-01-22 07:57 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-22 07:14 empty ryanne cruz <ryanne.cruz@up.edu.ph>
2003-01-22 07:36 ` Andrew McMillan <andrew@catalyst.net.nz>
2003-01-22 07:57   ` ryanne cruz <ryanne.cruz@up.edu.ph>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox