On 02/26/2014 03:03 PM, Sameer Kumar wrote:
>
> On Wed, Feb 26, 2014 at 6:54 PM, Vik Fearing <vik(dot)fearing(at)dalibo(dot)com
> <mailto:vik(dot)fearing(at)dalibo(dot)com>> wrote:
>
> You would be much better off to use the citext extension and
> typing your columns appropriately.
>
> http://www.postgresql.org/docs/current/static/citext.html
>
>
> That might be a huge effort while migrating from another database and
> might also introduce application level changes for type casting.
Not nearly as much effort as what you're trying to do, but good luck.
David's solution is what I would have suggested had he not said it already.
--
Vik