#271240 by mschiff: pgsql compatibility, left() doesn't exist but substr() exists in both pgsql and mysql.
