[GENERAL] UTF-8 and Regular expression

[Håvard Wahl Kongsgård]

Hi, in 8.4 how does the regular expression functions in postgresql handle
special UTF-8 characters?

for example:
SELECT name,substring(name from E'\\w+\\s(\\w+)$') from nodes;
fails to select characters like ü ø æ å

-- 
Håvard Wahl Kongsgård

http://havard.security-review.net/