tsvector_eq appears to be inconsistent.
От | Rajesh Kumar Mallah |
---|---|
Тема | tsvector_eq appears to be inconsistent. |
Дата | |
Msg-id | a97c77030611200109i1bc4f39by2d7028b0234e5c87@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: tsvector_eq appears to be inconsistent.
|
Список | 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 по дате отправления: