UTF-8 and Regular expression

[Håvard Wahl Kongsgård <haavard.kongsgaard@xxxxxxxxx>]

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 üåiv>

--
Hård Wahl Kongsgå

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