Re: [GENERAL] EXCEPTION in pl/pgsql

2005-07-19 Thread Hannes Dorbath
On 19.07.2005 20:56, Craig Bryden wrote: What is the syntax if I want to use the exception clause in a pl/pgsql function, but am not looking for a particular error. Kind of like a "any error" type thing. 35.7.5. Trapping Errors http://www.postgresql.org/docs/8.0/interactive/plpgsql-control-str

[GENERAL] EXCEPTION in pl/pgsql

2005-07-19 Thread Craig Bryden
Hi All What is the syntax if I want to use the exception clause in a pl/pgsql function, but am not looking for a particular error. Kind of like a "any error" type thing. some thing like: CREATE OR REPLACE FUNCTION func1(p_Param1 int4) RETURNS int4 AS $$ DECLARE v_Var1 int4; BEGIN [Sta