Re: Using HStore type in TSearch - Mailing list pgsql-hackers

From Łukasz Dejneka
Subject Re: Using HStore type in TSearch
Date
Msg-id 4df5da451003291005u6722397ew86c73107884adb8@mail.gmail.com
Whole thread Raw
In response to Re: Using HStore type in TSearch  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

2010/3/29 Tom Lane <tgl@sss.pgh.pa.us>
Łukasz Dejneka <l.dejneka@gmail.com> writes:
> What I want to do is to use HStore data type (namely the HStore keys) in
> TSearch. I don't want use TSVector and the original ts_match_vq function,
> because I want to be able to control exact values that are passed to the
> search and not use their lexemes.

If that's what you're after, why don't you set up a text search
configuration in which the parser/dictionary are trivial and do no
transformations of the strings (beyond perhaps splitting at whitespace)?
Seems a lot easier than constructing your own datatype and all the
required support functions.

                       regards, tom lane

Hi,

Thanks for the idea, but unfortunately it's not an option for me... This needs to be expendable in the near future, so need to be a coded as a separate function :/

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal - structured funcid and lineno as new fields in error message
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: Parallel pg_dump for 9.1