Kevin Grittner <[email protected]> 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 -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
