[GENERAL] Regular expressions w localization problem

2005-11-25 Thread Manuel Sugawara
I'm facing a problem I have seen before but never got the time to report until now that is biting me again. I have a table which has some CHECK constrains using regular expressions and one check is failing when I try to insert some valid data. The constraint definition is: «nombre propio válido»

Re: [GENERAL] Regular expressions w localization problem

2005-11-25 Thread Tom Lane
Manuel Sugawara masm@fciencias.unam.mx writes: I'm facing a problem I have seen before but never got the time to report until now that is biting me again. I have a table which has some CHECK constrains using regular expressions and one check is failing when I try to insert some valid data. The

Re: [GENERAL] Regular expressions w localization problem

2005-11-25 Thread Manuel Sugawara
Tom Lane [EMAIL PROTECTED] writes: I believe the meanings of [[:upper:]] and friends depend on the database locale, Indeed they depend on the locale settings, that's why this used to work. and the current code for them probably doesn't work at all in multibyte database encodings either.