Postgres 8.0 -> BEGIN EXCEPTION END Syntax???? - Mailing list pgsql-general

From Daniel Schuchardt
Subject Postgres 8.0 -> BEGIN EXCEPTION END Syntax????
Date
Msg-id cfil4v$2kiv$1@news.hub.org
Whole thread Raw
Responses Re: Postgres 8.0 -> BEGIN EXCEPTION END Syntax????
List pgsql-general
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

pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: Clustering, mirroriing, or replication?
Next
From:
Date:
Subject: Re: Clustering, mirroriing, or replication?