Martin Leja <Martin.Leja@unix-ag.uni-siegen.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