Re: [SQL] exception handling in postgres plpgsql

2007-04-03 Thread Tom Lane
Karthikeyan Sundaram <[EMAIL PROTECTED]> writes: > When I compile, I am getting an error message > ERROR: unrecognized exception condition "no_data_found"CONTEXT: compile o= > f PL/pgSQL function "audio_format_func" near line 15 > =20 > How will I handle exceptions in postgres? Reading between t

Re: [SQL] exception handling in postgres plpgsql

2007-04-03 Thread Joe
Hi, On Tue, 2007-04-03 at 15:35 -0700, Karthikeyan Sundaram wrote: > exception >when NO_DATA_FOUND >then > return 100; > end; > $$ > language 'plpgsql'; > > When I compile, I am getting an error message > ERROR: unrecognized exception condition "no_data_found" > CONTEXT: compi