Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9BBE39FB8B0 for ; Tue, 27 Mar 2007 11:20:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 41693-01-7 for ; Tue, 27 Mar 2007 11:20:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 202D29FB8F0 for ; Tue, 27 Mar 2007 11:20:17 -0300 (ADT) Received: (qmail invoked by alias); 27 Mar 2007 14:20:11 -0000 Received: from xdsl-87-78-222-63.netcologne.de (EHLO colt.pezone.net) [87.78.222.63] by mail.gmx.net (mp044) with SMTP; 27 Mar 2007 16:20:11 +0200 X-Authenticated: #495269 X-Provags-ID: V01U2FsdGVkX18gTgtA9lYg+gLkMxwKcjW8ZFLeJGN/DkJvRyvPNO gsbhtyQ+pYhYcS From: Peter Eisentraut To: pgsql-sql@postgresql.org Subject: Re: select vs. select count Date: Tue, 27 Mar 2007 16:20:08 +0200 User-Agent: KMail/1.9.5 Cc: "Claus Guttesen" References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200703271620.10123.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/314 X-Sequence-Number: 27952 Claus Guttesen wrote: > Why does select and select(count) produce two different results? count(expression) only counts nonnull values. -- Peter Eisentraut http://developer.postgresql.org/~petere/