From: Joe <dev@freedomcircle.net>
To: Karthikeyan Sundaram <skarthi98@hotmail.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] exception handling in postgres plpgsql
Date: Tue, 03 Apr 2007 19:30:43 -0400
Message-ID: <1175643043.756.1.camel@pampa> (raw)
In-Reply-To: <BAY131-W11D9F51A1A2E1E3AEFB6D8B0670@phx.gbl>
References: <BAY131-W11D9F51A1A2E1E3AEFB6D8B0670@phx.gbl>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@freedomcircle.net, skarthi98@hotmail.com, pgsql-admin@postgresql.org
Subject: Re: [SQL] exception handling in postgres plpgsql
In-Reply-To: <1175643043.756.1.camel@pampa>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox