On Wed, Jun 27, 2001 at 02:24:24AM +0100, Ryan Mahoney wrote: > *Disclaimer* - me sleepy, no guarantee of intelligebility or relevence ;) > > First thing that strikes me is that you should use varchar datatype for > almost all of your fields with the exception of the body within posts. > > If I were working on this project, I would... </lurk> slaver slaver > If you are interested in this approach, I can send you some PHP files (for > indexing documents and performing searches) and a stored procedure that > performs this type of search. The biggest downside of this method is that > maintaining the keyword and relationships can become a serious management > nightmare, especially if users can revise their posted messages. i'm game, drool drool. sign me up! -- I'd concentrate on "living in the now" because it is fun and on building a better world because it is possible. - Tod Steward [EMAIL PROTECTED] http://sourceforge.net/projects/newbiedoc -- we need your brain! http://www.dontUthink.com/ -- your brain needs us! ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl