Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> BTW, the corresponding error in the "SIMILAR TO ... ESCAPE ..." syntax is:
> postgres=# SELECT 'aa' SIMILAR TO 123 ESCAPE 'f';
> ERROR: function pg_catalog.similar_escape(integer, unknown) does not exist
> LINE 1: SELECT 'aa' SIMILAR TO 123 ESCAPE 'f';
> ^
Well, that's complaining specifically about the ESCAPE part of it.
This does expose the implementation detail that we try to build the
similar_escape() call before the overall similar() function call.
regards, tom lane