Error using odbc 11.00.0000

Поиск
Список
Период
Сортировка
От Walter Willmertinger
Тема Error using odbc 11.00.0000
Дата
Msg-id CAHbMG0U2qcfyJvgsEuP+8ydGawDQF7FJCMS8DdwEF7tqrrR96g@mail.gmail.com
обсуждение исходный текст
Список pgsql-bugs
Дерево обсуждения
After installation of this new release we have follwoing problem in an MS ACCESS project.
In a form there is a search window where a user can enter a search string.
The data source for this form is following query:

SELECT Interessenten.[ID]
FROM Interessenten
WHERE ((([Name] & ',' & [Vorname]) Like '*Ritter*')) OR (((Interessenten.Ort) Like '*müller*')) OR (((Interessenten.PLZ) Like '*müller*')) OR (((Interessenten.Handy) Like '*müller*'));

This query leads to an exception:
   ODBC Call failed (in german)
   ERROR: function concat(text,text) does not exist:
   Error while exection the query(#1)

If I omit the concatenation: ([Name] & ',' & [Vorname]) Like '*Ritter*'), the query is executed normally.

Environment: ODBC 64 Bit, Windows 10, Access 2013 
I already activated 

Regards

Walter Willmertinger

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: BUG #15356: Inconsistent documentation about CREATE TYPE
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15514: process fails on jsonb_populate_recordset query. seesimple example below