Skip site navigation (1) Skip section navigation (2)

exception handling in postgres plpgsql

From: Karthikeyan Sundaram <skarthi98(at)hotmail(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: exception handling in postgres plpgsql
Date: 2007-04-03 22:35:17
Message-ID: BAY131-W11D9F51A1A2E1E3AEFB6D8B0670@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-sql
Hi,
 
  I am having a function like this
 
create or replace function audio_format_func (    in p_bitrate audio_format.audio_bitrate%TYPE,    in p_sampling_rate audio_format.sampling_rate%type,    in p_bit_per_sample audio_format.bit_per_sample%type,    in p_audio_codec audio_format.audio_codec%type,    in p_mimetype audio_format.mimetype%type,    in p_mono_stero audio_format.number_of_channel%type) returns int as$$DECLARE  p_audio_id audio_format.audio_id%type;begin
   select  audio_id into a     from audio_format     where audio_bitrate = p_bitrate      and sampling_rate = p_sampling_rate      and mimetype = p_mimetype      and number_of_channel = p_mono_stero      and audio_code = p_audio_codec;
   return 1;  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
 
How will I handle exceptions in postgres?
 
Please advise.
 
Regards
skarthi
 
_________________________________________________________________
i'm making a difference. Make every IM count for the cause of your choice. Join Now.
http://clk.atdmt.com/MSN/go/msnnkwme0080000001msn/direct/01/?href=http://im.live.com/messenger/im/home/?source=wlmailtagline

Responses

pgsql-admin by date

Next:From: JoeDate: 2007-04-03 23:30:43
Subject: Re: [SQL] exception handling in postgres plpgsql
Previous:From: Andreas KretschmerDate: 2007-04-03 18:18:43
Subject: Re: plpgsql function question

pgsql-sql by date

Next:From: JoeDate: 2007-04-03 23:30:43
Subject: Re: [SQL] exception handling in postgres plpgsql
Previous:From: John DeSoiDate: 2007-04-03 20:27:16
Subject: Re: plpgsql function question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group