Martin Leja <Martin(dot)Leja(at)unix-ag(dot)uni-siegen(dot)de> writes:
> Why e.g. does the statement "select path from foo where path ~* '^/my';"
> not return the only entry "/My"? Can someone explain this?
I think you're getting bitten by the LIKE-index-optimization-in-non-
ASCII-locale problem. Are you running the server in a locale other
than "C"? See the many past threads about this type of issue ...
regards, tom lane