pg.ddx.io pgsql-php@postgresql.org mailing list archive
help / color / mirror / Atom feedempty
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