FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Suggestions » Implement postgresql ts_query
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Implement postgresql ts_query [message #164892] Tue, 29 March 2011 19:41 Go to next message
simonlnu is currently offline  simonlnu   Canada
Messages: 19
Registered: March 2011
Location: Tiohtiake
Karma: 0
Junior Member
ts_query supports whatever language you have on your forum, has been standard since 8.4 (IIRC), and is fast.

(I'm also having problems "rebuilding the search index" due to the migration, but that's another issue.)

I think it would be a plus to have this - mysql has similar functions, "full text search" or such.
Re: Implement postgresql ts_query [message #164893 is a reply to message #164892] Wed, 30 March 2011 02:12 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Sounds interesting. However, it will probably only work when messages are stored inside the database (possible with FUDforum, but the default is files).

How difficult would it be to implement ts_query and full text search?
Where can we find examples/ documentation?
Re: Implement postgresql ts_query [message #164894 is a reply to message #164893] Wed, 30 March 2011 02:34 Go to previous message
simonlnu is currently offline  simonlnu   Canada
Messages: 19
Registered: March 2011
Location: Tiohtiake
Karma: 0
Junior Member
That's a good point, hadn't thought of the messages in files not db. If this was implemented, it would have to have to have an indirect link that points to the wanted file(s). Or something Wink. Probably better to leave it as-is for now, and maybe keep it as a third-party plugin idea instead, for now.
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Modernize the design and look
Next Topic: Unread messages
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 28 04:23:25 GMT 2024

Total time taken to generate the page: 0.01995 seconds