Title: RE: [ADMIN] Mysql to postgres
Thankyou all for your feedback. Unfortunately, I think I may have to go down the lower() road of changing the code.
It will be far more time consuming, however there are other columns that are char,varchar,text etc.
Will definitely keep the citext
On Mon, Apr 11, 2005 at 03:02:01AM -0400, Tom Lane wrote:
> I think you could probably also do it by building a locale whose
> comparisons are case-insensitive, but I don't know enough about
> locales to be sure.
FWIW, this is how old versions of Sybase handled case insensitivity.
Pretty much ever
Theo Galanakis <[EMAIL PROTECTED]> writes:
> There may be a way to change the database in postgres to be case
> insensitive. i.e. change some of the operations such as "text=text" to be
> case insensitive. Does this sound Insane?
I think it would be exceedingly unwise to muck with the standard
beh
Title: Mysql to postgres
I have a legacy system that has been developed with a mysql backend. I'm in the process of converting it over to postgres. As postgres is case sensitive it appears as I will have to make numerous code changes from "like" to "ilike" and from e.g. "cola = cola" to "lowe
