Re: [HACKERS] plpgsql NULL statement (was Re: [GENERAL] Postgres 8.0 -> BEGIN EXCEPTION END Syntax????)

2004-08-15 Thread Andrew Dunstan
Tom Lane said: > Daniel Schuchardt <[EMAIL PROTECTED]> writes: >> BEGIN >> exception ... >> EXCEPTION >> WHEN OTHERS THEN ?what to write for do nothing? >> END; > >> in oracle it's >> WHEN OTHERS THEN null; >> but this syntax doesn't work in postgres. > > In Postgres you jus

[HACKERS] plpgsql NULL statement (was Re: [GENERAL] Postgres 8.0 -> BEGIN EXCEPTION END Syntax????)

2004-08-15 Thread Tom Lane
Daniel Schuchardt <[EMAIL PROTECTED]> writes: > BEGIN > exception ... > EXCEPTION > WHEN OTHERS THEN ?what to write for do nothing? > END; > in oracle it's > WHEN OTHERS THEN null; > but this syntax doesn't work in postgres. In Postgres you just write nothing at all: