Postgres Pro
Downloads
Home   >   mailing lists

Re: counting distinct rows on more than one column - Mailing list pgsql-sql

From Dirk Lutzebaeck
Subject Re: counting distinct rows on more than one column
Date
Msg-id 15042.15431.15325.327757@ampato.core.aeccom.com
Whole thread Raw
In response to Re: counting distinct rows on more than one column  (Michael Fork <mfork@toledolink.com>)
Responses Re: counting distinct rows on more than one column  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Function with now() | time 'now' | etc...
Next
From: Tom Lane
Date:
Subject: Re: counting distinct rows on more than one column