Postgres Pro
Downloads
Home   >   mailing lists

Re: tsvector_eq appears to be inconsistent. - Mailing list pgsql-sql

From Tom Lane
Subject Re: tsvector_eq appears to be inconsistent.
Date
Msg-id 7609.1164041434@sss.pgh.pa.us
Whole thread Raw
In response to tsvector_eq appears to be inconsistent.  ("Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>)
List pgsql-sql
Tree view 
"Rajesh Kumar Mallah" <mallah.rajesh@gmail.com> 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.)
        regards, tom lane

pgsql-sql by date:

Previous
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: transactional shared variable in postgresql
Next
From: "wen tseng"
Date:
Subject: How to find out top 3 records in each location