Our production instance of Moodle (v1.1.1) has a broken search function for PostgreSQL. The latest version (v1.2.1) has an appropriate fix.
The function get_users() in the file lib/datalib.php relied on a MySQL peculiarity to contatenate the first and last name fields together (with a space) to search. PostgreSQL does this differently. This bug report has the beginnings of the fix. Our beta instance (v1.2 beta) has the start of the fix, but uses double quotes where it should have single quotes. The latest release, v1.2.1 has an appropriate fix. I backported the v1.2 beta fix and used single quotes for the time being. We should have no problems when we upgrade to v1.2.1 or later.
Posted by Rowan Littell at April 14, 2004 09:01 AM