Off the top of my head, I can think of a couple of ways.
select lower(name), count(*) from customer group by lower(name);
or
select min(name), count(*) from customer group by lower(name);
The second one works if you still want some semblance of the original
casing of the field.
On Jun 28, 2004, at 9:15 AM, UMPA Development wrote:
Hello all!
Is it possible to setup a group by to be case insensitive and if so
how?
Thank you!
---------------------------(end of
broadcast)---------------------------
TIP 8: explain analyze is your friend
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org