pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSQL -select count-
3+ messages / 3 participants
[nested] [flat]
* SQL -select count-
@ 2002-11-19 17:06 Giannis <ogiannhs@yahoo.gr>
0 siblings, 2 replies; 3+ messages in thread
From: Giannis @ 2002-11-19 17:06 UTC (permalink / raw)
To: pgsql-sql
when I do :
select count(column_name) from table_name
should I get the count for all columns or just those which are not null?
__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - Let the expert host your site
http://webhosting.yahoo.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SQL -select count-
@ 2002-11-26 15:36 Richard Huxton <dev@archonet.com>
parent: Giannis <ogiannhs@yahoo.gr>
1 sibling, 0 replies; 3+ messages in thread
From: Richard Huxton @ 2002-11-26 15:36 UTC (permalink / raw)
To: Giannis <ogiannhs@yahoo.gr>; pgsql-sql
On Tuesday 19 Nov 2002 5:06 pm, Giannis wrote:
> when I do :
>
> select count(column_name) from table_name
>
> should I get the count for all columns or just those which are not null?
Just "not null" - use count(*) or count(0) for a count of rows.
--
Richard Huxton
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SQL -select count-
@ 2002-11-27 08:00 Achilleus Mantzios <achill@matrix.gatewaynet.com>
parent: Giannis <ogiannhs@yahoo.gr>
1 sibling, 0 replies; 3+ messages in thread
From: Achilleus Mantzios @ 2002-11-27 08:00 UTC (permalink / raw)
To: Giannis <ogiannhs@yahoo.gr>; +Cc: pgsql-sql
On Tue, 19 Nov 2002, Giannis wrote:
> when I do :
>
> select count(column_name) from table_name
>
> should I get the count for all columns or just those which are not null?
ÃéÜííç,
èá ðÜñåéò ôï ðëÞèïò ôùí êïëüíùí !! ðïõ äåí åßíáé null.
Ãéáôé äåí êÜíåéò Ýíá ôÝóô ìüíïò?
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Web Hosting - Let the expert host your site
> http://webhosting.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-10-8981112
fax: +30-10-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-11-27 08:00 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-11-19 17:06 SQL -select count- Giannis <ogiannhs@yahoo.gr>
2002-11-26 15:36 ` Richard Huxton <dev@archonet.com>
2002-11-27 08:00 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
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