| From: | Viliam Ďurina <viliam(dot)durina(at)kios(dot)sk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problem calling setweight function from JDBC |
| Date: | 2011-03-30 03:45:01 |
| Message-ID: | 4D92A73D.1060600@kios.sk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thank you, this helped.
Viliam
On 24.3.2011 16:08, Tom Lane wrote:
> =?utf-8?B?VmlsaWFtIMSOdXJpbmE=?=<viliam(dot)durina(at)kios(dot)sk> writes:
>> 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)
>
> Make that ::"char" not ::char ... the quotes matter here, because char
> without quotes is a keyword.
>
> regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Pan | 2011-03-30 08:07:33 | Re: OSX Postgres PL/Perl Problem with Finance::Quote/Options |
| Previous Message | Zheng Yang | 2011-03-30 03:00:24 | Re: foreign data wrappers |