[GRLUG] DBMAIL
Adam Tauno Williams
awilliam at whitemice.org
Fri Jul 17 07:38:07 EDT 2009
On Thu, 2009-07-16 at 22:19 -0400, Ben DeMott wrote:
> I've implemented FAST full text search quite a few times.
> Postgre's is great at it, and it's built in and simple to use.
Agree. And as a plug for Python's SQLalchemy - using PostgreSQL it
automatically generates text-search syntax for 'match' operations.
session.query(Contact).filter(Contact.firstName.match('Adam'))
- generates -
WHERE person.name @@ to_tsquery(%(name_1)s)
More information about the grlug
mailing list