Escaped characters in LIKE

Поиск
Список
Период
Сортировка
От Grant Shirreffs
Тема Escaped characters in LIKE
Дата
Msg-id BYAPR18MB3029A0A25F290FFB4D1BD139CF7A0@BYAPR18MB3029.namprd18.prod.outlook.com
обсуждение исходный текст
Список pgsql-odbc

PostgreSQL fully supports escaping of %, _ and \ in LIKE clauses, and supports the standard syntax for indicating the use of an escaping character:  https://www.postgresql.org/docs/9.0/functions-matching.html.

 

The ODBC driver correctly supports the standard ODBC ‘escape’ syntax for declaring the escaping character: (convert.c, line 5580).

 

So is there some reason I’m missing why the SQLGetInfo implementation, when asked SQL_LIKE_ESCAPE_CLAUSE, says that the driver doesn’t support escaping of LIKE? (info.c, line 309).  There is a comment in the code that indicates that the author wasn’t aware of the SQL syntax (‘is there a character that escapes '%' and '_' in a LIKE clause? not as far as I can tell’).

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Nathan Harrell
Дата:
Сообщение: Potential Windows ODBC 10.03.0000 Security Vulnerability
Следующее
От: Skovorodnikov Aleksey
Дата:
Сообщение: I want to know if the ODBC is installed on my computer