tsearch (or related) question

Started by Satoshi Nagayasuabout 15 years ago2 messagesgeneral
Jump to latest
#1Satoshi Nagayasu
satoshi.nagayasu@gmail.com

Hi all,

I'm looking for some tricky way for tsearch query.

Now, I know when a tsvector column has an array ('a', 'b', 'c'),
tsquery ('a&c') hits the row.

But I want to search rows with considering the order of tsvector
elements.

I want to hit a row when I use 'a&b' or 'b&c' in a tsquery,
but not 'a&c'.

Is this possible?

Regards,
--
NAGAYASU Satoshi <satoshi.nagayasu@gmail.com>

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Satoshi Nagayasu (#1)
Re: tsearch (or related) question

Satoshi Nagayasu <satoshi.nagayasu@gmail.com> writes:

I want to hit a row when I use 'a&b' or 'b&c' in a tsquery,
but not 'a&c'.

Wouldn't this do it?

tsvectorcol @@ '(a&b | b&c) & !(a&c)'

regards, tom lane