Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id EB7EE9FA433 for ; Tue, 21 Nov 2006 02:10:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 46001-01-2 for ; Tue, 21 Nov 2006 06:09:38 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.234]) by postgresql.org (Postfix) with ESMTP id E96409FA48B for ; Tue, 21 Nov 2006 02:09:21 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id i28so1973998wxd for ; Mon, 20 Nov 2006 22:09:21 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:mime-version:content-type:content-transfer-encoding:content-disposition; b=iILPBzYGecoUDEJVDjtsv42uD1i19n6gM7FiwZ6m7BCnjpn3r1S2qc9nTuWdqxkQn7FpvrnxHHD8NLg1Ttu3mR26FIJMXOdx7CcPlhs234O4fFjgnpMhh6KYCQ1qzr+Kx7ujSvhWDWkAbCVig4cGpJSj9XvS773L2euekWDKCE4= Received: by 10.90.84.17 with SMTP id h17mr4657640agb.1164089360312; Mon, 20 Nov 2006 22:09:20 -0800 (PST) Received: by 10.35.80.10 with HTTP; Mon, 20 Nov 2006 22:09:20 -0800 (PST) Message-ID: Date: Tue, 21 Nov 2006 11:39:20 +0530 From: "Rajesh Kumar Mallah" To: "Tom Lane" Subject: Re: tsvector_eq appears to be inconsistent. [ SOLVED (upgrade to 8.1.5) ] Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/222 X-Sequence-Number: 26874 On 11/20/06, Tom Lane wrote: > "Rajesh Kumar Mallah" writes: > > 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) > > IIRC, Teodor fixed a number of tsvector comparison bugs in 8.1.5 ... > try updating. (You might need to REINDEX any tsearch2 indexes > afterwards, not sure.) Yes its fixed in 8.1.5 Regds Mallah. tradein_clients=> SELECT tsvector_eq(to_tsvector('gift'),to_tsvector('gifts')); +-------------+ | tsvector_eq | +-------------+ | t | +-------------+ (1 row) tradein_clients=> SELECT tsvector_eq(to_tsvector('gift'),to_tsvector('birthday gifts')); +-------------+ | tsvector_eq | +-------------+ | f | +-------------+ (1 row) tradein_clients=> SELECT tsvector_eq(to_tsvector('gift'),to_tsvector('gifts')); +-------------+ | tsvector_eq | +-------------+ | t | +-------------+ (1 row) tradein_clients=> SELECT version(); +--------------------------------------------------------------------------------------------------------+ | version | +--------------------------------------------------------------------------------------------------------+ | PostgreSQL 8.1.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.1 (Mandrake Linux 9.2 3.3.1-2mdk) | +--------------------------------------------------------------------------------------------------------+ (1 row) > > regards, tom lane >