Artur Rataj <arataj(at)iitis(dot)gliwice(dot)pl> writes:
> Thank you. I needed the ~ operator to match entries in a table being a
> full text index itself. Now I use C locale and rows are sorted outside
> Postgres, the index now is used with the expressions of the form
> ~ '^string.*', but does such expressions work correctly in C locale with
> non-ASCII characters?
Don't see why they wouldn't --- in C locale, bytes are bytes. But you
should experiment before trusting that opinion ...
regards, tom lane