Re: [GENERAL] Tsearch2 can't be checked for equality?

2007-03-25 Thread Yonatan Ben-Nes
Well I got version 8.1.4 here and no option for upgrade... never mind I'll solve my problem in a different way. Thanks a lot, Ben-Nes Yonatan On 3/25/07, Oleg Bartunov wrote: What version ? in CVS HEAD I have postgres=# select to_tsvector('english', 'bh da') = to_tsvector('english', 'bh da'

Re: [GENERAL] Tsearch2 can't be checked for equality?

2007-03-25 Thread Tom Lane
Oleg Bartunov writes: > What version ? > ... > I think, it should works in 8.2 also. A look at the CVS log suggests it should work in 8.1.5 and later. regards, tom lane ---(end of broadcast)--- TIP 6: explain analyze is you

Re: [GENERAL] Tsearch2 can't be checked for equality?

2007-03-25 Thread Oleg Bartunov
What version ? in CVS HEAD I have postgres=# select to_tsvector('english', 'bh da') = to_tsvector('english', 'bh da'); ?column? -- t (1 row) I think, it should works in 8.2 also. Oleg On Sun, 25 Mar 2007, Yonatan Ben-Nes wrote: Hi all, I'm trying to compare between 2 tsvector fi

[GENERAL] Tsearch2 can't be checked for equality?

2007-03-25 Thread Yonatan Ben-Nes
Hi all, I'm trying to compare between 2 tsvector fields and I'm encountering a problem, for example: test.com=> SELECT 1 WHERE to_tsvector('default', 'bh da') = to_tsvector('default', 'bh da'); ?column? -- (0 rows) There is another way that I can check for equality of 2 tsvector fields