"Emanuel Brokmann" <brokmann.emanuel@ava.de> writes:
> while executing:
> >>BEGIN
> >> insert into comlineprintboxen VALUES(109, '', '', '', >>'', '');
> >>EXCEPTION
> >> WHEN unique_violation then
> >> UPDATE comlineprintboxen SET verteiler='', >>panel='', dose='',
> switch='', port='' WHERE >>printboxid=109
> >>END;
> the following error occurs:
> >>ERROR: syntax error at or near "UPDATE" at character 8
> i compared the command with the one from page 550 ff of the documentation,
> but can't find differences.
> Would be kind of you to help me
Can't help much with such an incomplete, mangled view of the problem :-(
You need to show us the full text of the CREATE FUNCTION command,
without random characters interspersed due to sloppy cut-and-paste.
regards, tom lane