Kevin Grittner <kgrittn@ymail.com> wrote:
>> If an update happens with a conditional of:
>>
>> where col1 = 'Abc'
>>
>> When col1 is 'ABC' using citext, should we still issue the
>> update?
>
> Absolutely not, because the update was requested in the case that
> the equality test was true.
Sorry, as if this thread were not long enough, I misread that and
gave the wrong answer. Yes, the equal operator was used and the
equal operator for two citext values says those are equal, so the
row *should* be updated.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company