Group by - Case insensitivity

[UMPA Development]

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

[Adam Ruth]

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

[Christopher Browne]

In the last exciting episode, de*@umpa-us.com (UMPA Development) wrote:

Is it possible to setup a group by to be case insensitive and if so how?

Well, you could presumably canonicalize the field to one case or the
other, thereby forcing the issue. That's not _exactly_ the same thing
as "case insensitivity," but it may be close enough.
--
output = reverse("gro.mc a" "@" "enworbbc")
http://www3.sympatico.ca/cbbrowne/x.html
Are you pondering what I'm pondering?

[Scott Marlowe]

On Mon, 2004-06-28 at 09:15, UMPA Development wrote:

Hello all!

Is it possible to setup a group by to be case insensitive and if so how?

group by lower(field)

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly