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)
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? |