tsvector_eq appears to be inconsistent.

From: "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: tsvector_eq appears to be inconsistent.
Date: 2006-11-20 09:09:32
Message-ID: a97c77030611200109i1bc4f39by2d7028b0234e5c87@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dimitri Fontaine 2006-11-20 09:16:32 Re: planner used functional index in 7.3.6, now does a seq
Previous Message Richard Huxton 2006-11-20 08:29:24 Re: query faster using LEFT OUTER join?