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 по дате отправления: