Problem calling setweight function from JDBC

Поиск
Список
Период
Сортировка
От Viliam Ďurina
Тема Problem calling setweight function from JDBC
Дата
Msg-id 4D8AFB09.1040205@kios.sk
обсуждение исходный текст
Ответы Re: Problem calling setweight function from JDBC  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello,

I have a call to setweight function in a PreparedStatement with the following sql:

update my_table set a_text_data=setweight(to_tsvector(? :: regconfig, ?), ? :: char)

Later I set the parameters:
stmt.setString(1, language);
stmt.setString(2, textToIndex);
stmt.setString(3, weight);

But the call fails with:

"ERROR: function setweight(tsvector, character) does not exist"

I had very similar error with ts_vector where the cast to regconfig helped, but not in this case. Inspecting the
setweightfunction in system catalogs shows that parameters are tsvector and char. What am I doing wrong? 

Thanks in advance,
Viliam


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

Предыдущее
От: Waqar Azeem
Дата:
Сообщение: Re: Database recovery.
Следующее
От: Harald Armin Massa
Дата:
Сообщение: Re: Database recovery.