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