Re: Complicated query... is there a simpler way? - Mailing list pgsql-general

From will trillich
Subject Re: Complicated query... is there a simpler way?
Date
Msg-id 20010629130648.I2985@serensoft.com
Whole thread Raw
In response to Re: Complicated query... is there a simpler way?  (Ryan Mahoney <ryan@paymentalliance.net>)
List pgsql-general
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

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: another stupid question: Database is being accessed by other users
Next
From: Jan Wieck
Date:
Subject: Re: (was: )