Re: Problem calling setweight function from JDBC

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

In response to

Browse pgsql-general by date

  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