Re: exception - Mailing list pgsql-general

From Klint Gore
Subject Re: exception
Date
Msg-id 491BC27F.7050306@une.edu.au
Whole thread Raw
In response to exception  ("hendra kusuma" <penguinroad@gmail.com>)
List pgsql-general
hendra kusuma wrote:
> but I really like to ask if there is a way to catch any exeption
> instead of defining what exception we would like to catch?
> something like ELSE or what :)
>

 From the manual

"The special condition name |OTHERS| matches every error type except
|QUERY_CANCELED|. "

klint.

--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350

Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4@une.edu.au


pgsql-general by date:

Previous
From: "hendra kusuma"
Date:
Subject: exception
Next
From: Russell Smith
Date:
Subject: Re: can someone help me to make a sql more pretty and more concise?