Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [SQL] exception handling in postgres plpgsql
- From: Joe <dev(at)freedomcircle(dot)net>
- To: Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com>
- Cc: pgsql-admin(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
- Subject: Re: [SQL] exception handling in postgres plpgsql
- Date: Tue, 03 Apr 2007 19:30:43 -0400
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: compile of PL/pgSQL function "audio_format_func" near line > 15 The constant is no_data. See http://www.postgresql.org/docs/8.2/static/errcodes-appendix.html Joe
- References:
- exception handling in postgres plpgsql
- From: Karthikeyan Sundaram
- exception handling in postgres plpgsql
- Prev by Date: exception handling in postgres plpgsql
- Next by Date: Re: [SQL] exception handling in postgres plpgsql
- Previous by thread: exception handling in postgres plpgsql
- Next by thread: Re: [SQL] exception handling in postgres plpgsql
- Indexes: