Re: PLPGSQL/EXCEPTION HANDLING

On 6/12/06, renneyt@yahoo.com <renneyt@yahoo.com> wrote:
> In a function implemented in 7.4.8 I had the following error when I call
> the function:
>
> ERROR:  syntax error at or near "EXCEPTION"
>
> Offending line is:
>     EXCEPTION WHEN dup_val_on_index THEN NULL;
>
> When this line is removed, all is well.
>

that's because that construction was added in 8.0, you have to upgrade to use it

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook