From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Giannis <ogiannhs@yahoo.gr>
Cc: pgsql-sql@postgresql.org
Subject: Re: SQL -select count-
Date: Wed, 27 Nov 2002 10:00:37 +0200 (EET)
Message-ID: <Pine.LNX.4.44.0211270958200.24730-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <00cf01c28fee$144d8bd0$dd4186c3@edunet.uoa.gr>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, ogiannhs@yahoo.gr
Subject: Re: SQL -select count-
In-Reply-To: <Pine.LNX.4.44.0211270958200.24730-100000@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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