Re: exception handling in postgres plpgsql - Mailing list pgsql-sql

From Joe
Subject Re: exception handling in postgres plpgsql
Date
Msg-id 1175643043.756.1.camel@pampa
Whole thread Raw
In response to exception handling in postgres plpgsql  (Karthikeyan Sundaram <skarthi98@hotmail.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Karthikeyan Sundaram
Date:
Subject: exception handling in postgres plpgsql
Next
From: Tom Lane
Date:
Subject: Re: exception handling in postgres plpgsql