Received: from k3.core.aeccom.com (gate2.aeccom.com [195.211.178.194]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2SJX8U63171 for ; Wed, 28 Mar 2001 14:33:08 -0500 (EST) (envelope-from lutzeb@aeccom.com) Received: from ampato.core.aeccom.com (IDENT:root@ampato.core.aeccom.com [192.168.2.11]) by k3.core.aeccom.com (8.9.3/8.9.3) with ESMTP id VAA11910; Wed, 28 Mar 2001 21:33:03 +0200 Received: (from lutzeb@localhost) by ampato.core.aeccom.com (8.9.3/8.9.3) id VAA02127; Wed, 28 Mar 2001 21:33:03 +0200 From: Dirk Lutzebaeck MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <15042.15431.15325.327757@ampato.core.aeccom.com> Date: Wed, 28 Mar 2001 21:32:23 +0200 (CEST) To: Michael Fork Cc: pgsql-sql@postgresql.org Subject: Re: counting distinct rows on more than one column In-Reply-To: References: <15041.65308.150764.131312@ampato.core.aeccom.com> X-Mailer: VM 6.72 under 21.1 (patch 12) "Channel Islands" XEmacs Lucid X-Archive-Number: 200103/587 X-Sequence-Number: 2257 Michael Fork writes: > In 7.0.3, I believe the following would work: > > SELECT count(distinct(a || b)) FROM t; Great, this works! I don't quite get it why... Dirk