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