Postgres 8.0 -> BEGIN EXCEPTION END Syntax????

From: Daniel Schuchardt <daniel_schuchardt(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres 8.0 -> BEGIN EXCEPTION END Syntax????
Date: 2004-08-13 15:02:00
Message-ID: cfil4v$2kiv$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi ,

can anybody tell me the postgres - syntax for begin excepion end if I
want to ignore the error?

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.

thnx

Daniel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shelby Cain 2004-08-13 15:39:39 Postgresql 8.0 beta 1 service issue
Previous Message Lincoln Yeoh 2004-08-13 14:24:44 Re: Clustering, mirroriing, or replication?

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Huxton 2004-08-13 15:20:04 Re: Weird Database Performance problem!
Previous Message Gaetano Mendola 2004-08-13 14:52:47 hot spare / log shipping work on