Search Postgresql Archives

tsearch (or related) question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx>

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux