"Patrick Fiche" <patrick.fiche@aqsacom.com> writes:
> SELECT 'Begin' || LEFT( 'String1', 3 ) -> ERROR: parser: parse error at or
> near "LEFT"
Use a different function name. LEFT is a reserved word, and while PG
will let you get away with using it as a function name anyway, there
are situations like this where the normal interpretation of the keyword
takes precedence.
I've tweaked the grammar for 7.3 so that this particular case works,
but you'd still have similar problems if you were to use, say, BETWEEN
as a function name.
regards, tom lane