[Zope-dev] Searching a relational database

[Thomas Weholt]

Hi,   How can I search a relational database thru Zope? ( I`m using PostgreSQL 7.0.2 on Linux ). I have a DVD/VHS-organizing project that would be pretty useless if people couldn`t search for movies by entering just parts of the title.   Ex. typing alien should show "Alien" and "Alien 3".   Can ZCatalog be used for this? If I have a SQL-statement that returns all rows in a database, can ZCatalog index this?   What I`m looking for is similar to full-text searching on MS SQL 7.0 etc.   Tips, hints or pointers??   Thomas