Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 45A30475B07 for ; Wed, 27 Nov 2002 02:52:22 -0500 (EST) Received: from matrix.gatewaynet.com (unknown [217.19.69.50]) by postgresql.org (Postfix) with ESMTP id CADC9475AEC for ; Wed, 27 Nov 2002 02:52:20 -0500 (EST) Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.11.6/8.11.6) with ESMTP id gAR80bM24749; Wed, 27 Nov 2002 10:00:37 +0200 Date: Wed, 27 Nov 2002 10:00:37 +0200 (EET) From: Achilleus Mantzios To: Giannis Cc: pgsql-sql@postgresql.org Subject: Re: SQL -select count- In-Reply-To: <00cf01c28fee$144d8bd0$dd4186c3@edunet.uoa.gr> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-7 Content-Transfer-Encoding: 8BIT X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/413 X-Sequence-Number: 10555 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