We just had a complaint on IRC that: devel=# select 'blah foo bar'::tsvector = 'blah foo bar'::tsvector; ?column? ---------- f (1 row)
and that searches for certain values would not return all matches under some circumstances. a little bit of testing shows the following: postgres=# create table foo (bla tsvector); CREATE TABLE postgres=# insert into foo values ('bla bla'); INSERT 0 1 postgres=# insert into foo values ('bla bla'); INSERT 0 1 postgres=# select bla from foo group by bla; bla ------- 'bla' (1 row) postgres=# create index foo_idx on foo(bla); CREATE INDEX postgres=# set enable_seqscan to off; SET postgres=# select bla from foo group by bla; bla ------- 'bla' 'bla' (2 rows) postgres=# set enable_seqscan to on; SET postgres=# select bla from foo group by bla; bla ------- 'bla' (1 row) ouch :-( I can reproduce that at least on OpenBSD/i386 and Debian Etch/x86_64. It is also noteworthy that the existing regression tests for tsearch2 do not seem to do any equality testing ... Stefan ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly