Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3BEB1475E5E for ; Tue, 19 Nov 2002 12:00:42 -0500 (EST) Received: from smtp011.mail.yahoo.com (smtp011.mail.yahoo.com [216.136.173.31]) by postgresql.org (Postfix) with SMTP id 1DD5C475CE7 for ; Tue, 19 Nov 2002 12:00:40 -0500 (EST) Received: from moon.edunet.uoa.gr (HELO moon) (ogiannhs@195.134.65.221 with login) by smtp.mail.vip.sc5.yahoo.com with SMTP; 19 Nov 2002 17:00:44 -0000 Message-ID: <00cf01c28fee$144d8bd0$dd4186c3@edunet.uoa.gr> From: "Giannis" To: Subject: SQL -select count- Date: Tue, 19 Nov 2002 19:06:57 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-7" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1123 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1123 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/388 X-Sequence-Number: 10530 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