Could anyone tell me if the string manipulators 'left',right' and 'substr' are working in postgres yet. I keep getting parse errors. ex: select left(name,3) from example; Should give me the first three letters but instead I get 'parse error at or near left'. Thanks Doug