From: | Viliam Ďurina <viliam(dot)durina(at)kios(dot)sk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Problem calling setweight function from JDBC |
Date: | 2011-03-24 08:04:25 |
Message-ID: | 4D8AFB09.1040205@kios.sk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 setweight function in system catalogs shows that parameters are tsvector and char. What am I doing wrong?
Thanks in advance,
Viliam
From | Date | Subject | |
---|---|---|---|
Next Message | Zheng Yang | 2011-03-24 08:49:19 | Re: foreign data wrappers |
Previous Message | Guillaume Lelarge | 2011-03-24 07:54:42 | Re: foreign data wrappers |