From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: pgsql-sql@postgresql.org
Subject: tsvector_eq appears to be inconsistent.
Date: Mon, 20 Nov 2006 14:39:32 +0530
Message-ID: <a97c77030611200109i1bc4f39by2d7028b0234e5c87@mail.gmail.com> (raw)
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah.rajesh@gmail.com
Subject: Re: tsvector_eq appears to be inconsistent.
In-Reply-To: <a97c77030611200109i1bc4f39by2d7028b0234e5c87@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox