Bruce Momjian <[EMAIL PROTECTED]> writes:
> clamped to 16383. Duplicate position entries are discarded.
> ----------------------------------------
> However in my testing of 8.3 duplicate position entries are not
> discarded:
> test=> SELECT 'a:1 b:1'::tsvector;
> tsvector
> -------------
> 'a':1 'b':1
> (1 row)
Those aren't duplicates, because they're not attached to the same
lexeme. The comment is talking about this behavior:
regression=# SELECT 'a:1 a:1'::tsvector;
tsvector
----------
'a':1
(1 row)
regression=# SELECT 'a:1,2,1'::tsvector;
tsvector
----------
'a':1,2
(1 row)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
