Skip site navigation (1) Skip section navigation (2)

tsearch2 headline function fails to parse integer arguments

From: "Tom Hebbron" <postgresql(dot)org(at)hebbron(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: tsearch2 headline function fails to parse integer arguments
Date: 2005-01-06 21:29:02
Message-ID: crkaj9$2f1n$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-www
SELECT headline('some text to search',to_tsquery('text'),'StartSel=<b>, 
StopSel=</b>, ShortWord=3')

On 8.0beta1 through 8.0rc3 this query fails with
ERROR: invalid input syntax for integer: "3"

The same is reported when using any of the argument in the option string 
that take integers (MinWords and MaxWords)
e.g.

SELECT headline('some text to search',to_tsquery('text'),'StartSel=<b>, 
StopSel=</b>, MaxWords=35, MinWords=15, ShortWord=3');

ERROR:  invalid input syntax for integer: "35"

Using the bundled tsearch2 from PostgreSQL 7.4.3 the headline function works 
as expected, and the above examples return without error.

There also seems to be a problem with the bug submission form on the 
website - the wwwmaster.postgresql.org server that handles the POST data 
doesn't respond - it appears to be down?



Responses

pgsql-www by date

Next:From: nobodyDate: 2005-01-06 22:11:28
Subject: Comment 1969 added to page installation.html of version 7.4
Previous:From: Josh BerkusDate: 2005-01-06 19:07:40
Subject: Re: Comments to www list

pgsql-bugs by date

Next:From: 王亮Date: 2005-01-07 05:48:10
Subject: How to intall postgresql-docs-7.4.6 on win2000?
Previous:From: Hans-Jürgen SchönigDate: 2005-01-06 09:44:02
Subject: Re: File Groups with postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group