> 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.
