Does anybody know if 'LEFT','RIGHT','SUBSTR' are working with psql,I keep getting the magical parse error at or near 'left'.Thanks