Search Postgresql Archives

Problem calling setweight function from JDBC

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 setweight function in system catalogs shows that parameters are tsvector and char. What am I doing wrong?

Thanks in advance,
Viliam


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux