Re: [GENERAL] How to use the full text index feature on PostgreSQL

2006-08-13 Thread Chris
Alvaro Herrera wrote: Joshua D. Drake wrote: Matthew T. O'Connor wrote: Chris wrote: aBBISh wrote: You need to install & setup tsearch2. I have a small article about how to do that here: http://www.designmagick.com/article/27/ Also on page 3 you say, "(normal indexes will only index the firs

Re: [GENERAL] How to use the full text index feature on PostgreSQL

2006-08-11 Thread Alvaro Herrera
Joshua D. Drake wrote: > Matthew T. O'Connor wrote: > >Chris wrote: > >>aBBISh wrote: > >>You need to install & setup tsearch2. > >> > >>I have a small article about how to do that here: > >> > >>http://www.designmagick.com/article/27/ > > > >Also on page 3 you say, "(normal indexes will only index

Re: [GENERAL] How to use the full text index feature on PostgreSQL

2006-08-11 Thread Joshua D. Drake
Matthew T. O'Connor wrote: Chris wrote: aBBISh wrote: You need to install & setup tsearch2. I have a small article about how to do that here: http://www.designmagick.com/article/27/ Also on page 3 you say, "(normal indexes will only index the first 255 characters of a 'text' field)." Is t

Re: [GENERAL] How to use the full text index feature on PostgreSQL

2006-08-11 Thread Matthew T. O'Connor
Chris wrote: aBBISh wrote: You need to install & setup tsearch2. I have a small article about how to do that here: http://www.designmagick.com/article/27/ Also on page 3 you say, "(normal indexes will only index the first 255 characters of a 'text' field)." Is that true? -

Re: [GENERAL] How to use the full text index feature on PostgreSQL

2006-08-11 Thread Matthew T. O'Connor
Chris wrote: You need to install & setup tsearch2. I have a small article about how to do that here: http://www.designmagick.com/article/27/ Nice article, very clear and concise, however one small nit. At the end of page I don't think you need the vacuum full, vacuum may or may not be use

Re: [GENERAL] How to use the full text index feature on PostgreSQL

2006-08-10 Thread Chris
aBBISh wrote: Chris 写道: aBBISh wrote: Hello everyone How to use the full text index feature to search a lot of text on PostgreSQL 8.x? You need to install & setup tsearch2. I have a small article about how to do that here: http://www.designmagick.com/article/27/ That article so good,tha

Re: [GENERAL] How to use the full text index feature on PostgreSQL

2006-08-10 Thread aBBISh
Chris 写道: aBBISh wrote: Hello everyone How to use the full text index feature to search a lot of text on PostgreSQL 8.x? You need to install & setup tsearch2. I have a small article about how to do that here: http://www.designmagick.com/article/27/ That article so good,thank you. Can yo

Re: [GENERAL] How to use the full text index feature on PostgreSQL

2006-08-10 Thread Chris
aBBISh wrote: Hello everyone How to use the full text index feature to search a lot of text on PostgreSQL 8.x? You need to install & setup tsearch2. I have a small article about how to do that here: http://www.designmagick.com/article/27/ -- Postgresql & php tutorials http://www.designmagic

[GENERAL] How to use the full text index feature on PostgreSQL 8.x

2006-08-10 Thread aBBISh
Hello everyone How to use the full text index feature to search a lot of text on PostgreSQL 8.x? thank you~! ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq