Re: [SQL] Efficient Searching of Large Text Fields

2006-06-14 Thread Oleg Bartunov
On Wed, 14 Jun 2006, Achilleus Mantzios wrote: O Oleg Bartunov ?? Jun 14, 2006 : Don't invent a wheel and use contrib/tsearch2 for that. Hi Oleg, i just wanted to ask if anything close to exact phrase matching could be deployed/implemented with tsearch2. not yet, but doable, sinc

Re: [SQL] Efficient Searching of Large Text Fields

2006-06-14 Thread Oleg Bartunov
On Tue, 13 Jun 2006, Aaron Bono wrote: I will look that tsearch (at . It appears their 8.1.x version is still in development and I use PostgreSQL 8.1.3 but it is worth trying - I'm not in a hurry for that feature anyway. I also looked at PHPBB a little - it appears their database stores words

Re: [SQL] Efficient Searching of Large Text Fields

2006-06-14 Thread Achilleus Mantzios
O Oleg Bartunov έγραψε στις Jun 14, 2006 : > Don't invent a wheel and use contrib/tsearch2 for that. Hi Oleg, i just wanted to ask if anything close to exact phrase matching could be deployed/implemented with tsearch2. > > On Tue, 13 Jun 2006, Aaron Bono wrote: > > > In another post on a dif

Re: [SQL] Efficient Searching of Large Text Fields

2006-06-14 Thread Oleg Bartunov
Don't invent a wheel and use contrib/tsearch2 for that. On Tue, 13 Jun 2006, Aaron Bono wrote: In another post on a different topic, Rod Taylor said the following: "A\tcat in the\nhat" might be stored as ARRAY['A', 'cat', 'in', 'the', 'hat']. This got me thinking. I have a discussion for

Re: [SQL] Efficient Searching of Large Text Fields

2006-06-13 Thread Aaron Bono
I will look that tsearch (at . It appears their 8.1.x version is still in development and I use PostgreSQL 8.1.3 but it is worth trying - I'm not in a hurry for that feature anyway. I also looked at PHPBB a little - it appears their database stores words but the code is so difficult to dig throu

Re: [SQL] Efficient Searching of Large Text Fields

2006-06-13 Thread PFC
2. What functions or libraries are available to make such searching easy to implement well? the tsearch2 module does that, and has a substantial advantage over a solution you might reimplement : it's already done (and it works). Try it... ---(end of broadcast)-

Re: [SQL] Efficient Searching of Large Text Fields

2006-06-13 Thread Rod Taylor
On Tue, 2006-06-13 at 15:30 -0500, Aaron Bono wrote: > In another post on a different topic, Rod Taylor said the following: > > "A\tcat in the\nhat" might be stored as ARRAY['A', 'cat', 'in', 'the', > 'hat']. > > This got me thinking. I have a discussion forum for gamers and want > to provide

[SQL] Efficient Searching of Large Text Fields

2006-06-13 Thread Aaron Bono
In another post on a different topic, Rod Taylor said the following: "A\tcat in the\nhat" might be stored as ARRAY['A', 'cat', 'in', 'the', 'hat']. This got me thinking. I have a discussion forum for gamers and want to provide searching capabilities so the user can type in a phrase like "magi