Re: BUG #5356: citext not acting like case insensitive search

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Michael Gould" <mgould(at)intermodalsoftwaresolutions(dot)net>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5356: citext not acting like case insensitive search
Date: 2010-03-01 18:39:03
Message-ID: B209E4B2-6696-4054-B321-409446E8BDC6@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mar 1, 2010, at 10:25 AM, Tom Lane wrote:

> Not sure if there is anything we can do to make this much nicer.
> Removing the implicit cast seems like a cure worse than the disease,
> particularly because it would result in throwing a "no such operator"
> error rather than actually doing what Michael would like.

Yes, I suspect that he can solve his problem by adding the iss schema to search_path.

Best,

David

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2010-03-01 19:20:20 Re: BUG #5355: locale incorrectly comma-separates "(null)"
Previous Message Heikki Linnakangas 2010-03-01 18:38:05 Re: BUG #5355: locale incorrectly comma-separates "(null)"