On Tue, 21 Oct 2008 10:29:52 +0200
Ivan Sergio Borgonovo <mail@webthatworks.it> wrote:
I came across this:
http://grokbase.com/topic/2007/08/07/general-tsearch2-plainto-tsquery-with-or/r92nI5l_k9S4iKcWdCxKs05yFQk
And I find it is strictly related to my needs.
Working around ts_parse I could get an array of tokens, filter on
the one that are not considered significative and get an array
similar to: strip(to_tsvector(...))
Since now I've an array I could then loop on it and build up a
ts_query according to my needs.
While Mike Rylander's solution may work the regexp is not a good
enough substitute for tsearch2 parser.
I didn't have the time to look at the source code (and actually I'd
feel a bit pity to download some Mb to just look at a function) but
I bet all the code spend a lot of time to turn strings into
tsvectors.
If there were more tools to manipulate and turn tsvectors into
tsquery we could build more interesting search functions in plpsql
et al. and maybe cache some of the conversions (string -> tsvector)
inspite of spending time serializing an de-serializing stuff.
But here is the more pragmatical question:
### LOOK HERE FIRST ;) ####
Or am I missing something of the already available
functions/operations?
> plainto_tsquery is handy to make a string from users turn into a
> tsquery.
>
> This strips "control" characters and glue lexemes with &.
> Now I've several strings coming from input user and what I'd like
> to do is assign a different token to each part.
>
> eg.
> input1 = "ratto && matto | gatto & the"
> input2 = "sasso|&passo lasso a"
> ->
> tsquery = 'ratto:A & matto:A & gatto:A & sasso:B & passo:B &
> lasso:B'
>
> I could prepare the input outside postgresql and then
> "concatenate" the queries but plainto_tsquery is very comfortable
> since it will always actually "clean up" the right way the input
> and adds & at the right place.
>
> Otherwise I could use more than one tsvector for searching input1
> and input2 but it seems it is slower than
> update t1 set FT1IDX=(
>
> setweight(to_tsvector('pg_catalog.english',
> coalesce(input1,'')), 'A') || ' ' ||
>
> setweight(to_tsvector('pg_catalog.english',
> coalesce(input2,'')), 'B')
> )
>
> and I won't be able rank on all fields at a time.
>
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
