Hi, Tom,
Tom Lane wrote:
> No, it should be something like
>
> syntax error in tsearch query: "contents of string"
>
> since it's not always the case that you know exactly what string got fed
> to to_tsquery().
I agree.
It's also possible that you have more than one tsearch expression i
Martijn van Oosterhout writes:
> On Tue, Oct 03, 2006 at 04:34:06PM +0200, Magnus Hagander wrote:
>> search=3D# select to_tsquery('foo bar');
>> ERROR: syntax error
> Seems to me, at the very least, the message should be:
> ERROR: tsearch: syntax error
No, it should be something like
s
On Tue, Oct 03, 2006 at 04:34:06PM +0200, Magnus Hagander wrote:
> search=# select to_tsquery('foo bar');
> ERROR: syntax error
Seems to me, at the very least, the message should be:
ERROR: tsearch: syntax error
Then people have an idea where it comes from.
Have a nice day,
--
Martijn van Oos
This is great news- previously, I was using various regexes to sanitize
input into user-accessible search fields. Would it be build in some
simple query language?
"sam AND spade"
"blue OR yellow"
"(same AND spade) OR (blue AND yellow)"
That's exactly to_tsquery syntax, just change AND to & an
On Oct 3, 2006, at 10:49 , Oleg Bartunov wrote:
On Tue, 3 Oct 2006, Magnus Hagander wrote:
BTW, try
# select plainto_tsquery('foo bar');
plainto_tsquery
-
'foo' & 'bar'
(1 row)
It parses plain text and makes tsquery. Function exists only in 8.2
- some later we add docs ab
On Tue, 3 Oct 2006, Magnus Hagander wrote:
BTW, try
# select plainto_tsquery('foo bar');
plainto_tsquery
-
'foo' & 'bar'
(1 row)
It parses plain text and makes tsquery. Function exists only in 8.2
- some later we add docs about changes in tsearch2.
Current docs, covering 8
> > Might want to enhance that message to include the information
> that
> > it's parsing the tsquery that's failing? I originally had it as
> part
> > of a much larger query, and it took me a while to remember that
> it's
> > tsearch that spits out that very generic error message.
> It possible, b
Might want to enhance that message to include the information that it's
parsing the tsquery that's failing? I originally had it as part of a
much larger query, and it took me a while to remember that it's tsearch
that spits out that very generic error message.
It possible, but not for 8.2 :(
BT
search=# select to_tsquery('foo bar');
ERROR: syntax error
Might want to enhance that message to include the information that it's
parsing the tsquery that's failing? I originally had it as part of a
much larger query, and it took me a while to remember that it's tsearch
that spits out that very
