Re: Case insensitive collation - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Case insensitive collation
Date
Msg-id CAF-3MvNsNHPmQoVUmbQrELKZ1ske3sO=QcrpUbX9QqGyirHnsQ@mail.gmail.com
Whole thread Raw
In response to Re: Case insensitive collation  (Marcel van Pinxteren <marcel.van.pinxteren@gmail.com>)
List pgsql-general
On 21 January 2013 17:25, Marcel van Pinxteren <marcel.van.pinxteren@gmail.com> wrote:
The other reason, is that I assume that "lower()" adds overhead, so makes things slower than they need to be.
Whether that is true, and if that is a compelling reason, I don't know.

Case insensitive collation adds overhead too. It wouldn't surprise me if that were more than lower() adds - collation is complicated stuff.
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

pgsql-general by date:

Previous
From: Marcel van Pinxteren
Date:
Subject: Re: Case insensitive collation
Next
From: bhanu udaya
Date:
Subject: Re: pg_Restore