Re: [SQL] counting distinct rows on more than one column

[Dirk Lutzebaeck]

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly