> Thank you, pushed with some editorization and renaming text_startswith to
> starts_with
I am sorry for not noticing this before, but what is the point of this
operator? It seems to me we are only making the prefix searching
business, which is already complicated, more complicated.
Also, the new operator is not documented on SQL String Functions and
Operators table. It is not supported by btree text_pattern_ops or
btree indexes with COLLATE "C". It is not defined for "citext", so
people would get wrong results. It doesn't use pg_trgm indexes
whereas LIKE can.