Re: counting distinct rows on more than one column

From: Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com>
To: Michael Fork <mfork(at)toledolink(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: counting distinct rows on more than one column
Date: 2001-03-28 19:32:23
Message-ID: 15042.15431.15325.327757@ampato.core.aeccom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-03-28 19:51:39 Re: counting distinct rows on more than one column
Previous Message Tom Lane 2001-03-28 19:22:02 Re: Function with now() | time 'now' | etc...