>Marcel ([EMAIL PROTECTED]) reports a bug with a severity of 3 >The lower the number the more severe it is. > >Short Description >Select where (upper(xy)~'.CH'); ..matches also SPACE CH > >Long Description >There exists a problem with the ~ statement. The codesample and the text is >from an adult contact database. > >The compare string .CH matches the word 'EINEN CHANCE' in the sentence. >Seems to be, that the . will match the space between the words. This >doesn't happen, if you replace .CH with _CH or something else. Strange. The string '.CH' should match any single character directly followed by 'CH'. It *should* match '_CH' as well as ' CH'. If you want the "." to match something, then use the appropriate list [a-zA-Z] for alphabetical characters and suchwhat. If you want to match the "." character, then use '\.CH'. Question: why aren't you using ~* (which does a case insensitive match) rather than upper(xy) ~ '.CH'? I haven't done benchmarking so I don't know which is faster... I hope this helps. -- D. Jay Newman ! For the pleasure and the profit it derives [EMAIL PROTECTED] ! I arrange things, like furniture, and http://www.sprucegrove.com/~jay/ ! daffodils, and ...lives. -- Hello Dolly
