[GENERAL] PostgreSQL full text vs. MySQL

Hey all,

I have been a MySQL user for a number of years,
but just read about PostgreSQL version 8.3 and was
especially intrigued and interested in the full
text search implementation using lexemes.

I'm currently doing the specs for a PHP app that
will involve up to the millions records to search,
and it will need full text capability.

I am wondering if I could get some opinions on
PostgreSQL's full text versus MySQL's and
specifically I have not been able to find
documentation that MySQL supports lexeme type full
text, able to locate root words the way PostgreSQL
8.3 does.

Is this the case? I could certainly justify the
switch to PostgreSQL if I can make a solid case to
the client for doing so.

I realize this is a PostgreSQL list, so let's try
to be fair ;)

Thanks!
--
Skip Evans
Big Sky Penguin, LLC
503 S Baldwin St, #1
Madison, WI 53703
608-250-2720
http://bigskypenguin.com
=-=-=-=-=-=-=-=-=-=
Check out PHPenguin, a lightweight and versatile
PHP/MySQL, AJAX & DHTML development framework.
http://phpenguin.bigskypenguin.com/

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general