I've never had any hassles with 'where upper(fieldName) like '%FIND %' with pg
Sure, but keep in mind this is an unindexed search, just like a REGEX search is. It puts an extra strain on your database and the query should take longer to process. This said, with the power of servers nowadays, speed is hardly an issue, unless you're developing an application that will take hundreds of hits per second.
Best regards Peter De Berdt _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
