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 constraint
> definition is:
> «nombre propio válido» CHECK (nombre ~ '^[[:upper:]][[:lower:]]*([-\'.
> [:alpha:]]+)?$'::text)
> And the data is ``José Luis''.
I believe the meanings of [[:upper:]] and friends depend on the database
locale, and the current code for them probably doesn't work at all in
multibyte database encodings either. So, what locale and encoding
are you using?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
