----- Original Message ----- > "Donald Fraser" <[EMAIL PROTECTED]> writes: > > PostgreSQL 7.3.x and anything below has never had case insensitive sorting = > > - period. > > This is incorrect. In point of fact it will depend on the locale the > database is running under. I think the OP's problem is he re-initdb'd > without noting what locale setting was active.
Correction noted. I over-looked the fact that a local setting can provide different collation ordering. Out of interest, which local settings will give a case-insensitive collation order? Regards Donald Fraser ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
