tsvector_eq appears to be inconsistent. - Mailing list pgsql-sql

From Rajesh Kumar Mallah
Subject tsvector_eq appears to be inconsistent.
Date
Msg-id a97c77030611200109i1bc4f39by2d7028b0234e5c87@mail.gmail.com
Whole thread Raw
Responses Re: tsvector_eq appears to be inconsistent.
List pgsql-sql
Hi,

I am doing equality comparisons on type tsvector using tsvector_eq.
How come a comparison that returns true before starts returning false
afterwards ?  (see results of case 1 and 3)

Regds
mallah.

(1)
tradein_clients=# SELECT tsvector_eq(to_tsvector('gift'),to_tsvector('gifts'));
tsvector_eq
-----------
t

(2)

tradein_clients=# SELECT
tsvector_eq(to_tsvector('gift'),to_tsvector('birthday gifts'));
tsvector_eq
-----------
f

(3)
tradein_clients=# SELECT tsvector_eq(to_tsvector('gift'),to_tsvector('gifts'));
tsvector_eq
-----------
f


tradein_clients=# SELECT version();                                              version
------------------------------------------------------------------------------------------------------
PostgreSQL 8.1.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.1
(Mandrake Linux 9.2 3.3.1-2mdk)


pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: query faster using LEFT OUTER join?
Next
From: Dimitri Fontaine
Date:
Subject: Re: planner used functional index in 7.3.6, now does a seq