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 >