Karthikeyan Sundaram <[EMAIL PROTECTED]> writes:
> When I compile, I am getting an error message
> ERROR: unrecognized exception condition "no_data_found"CONTEXT: compile o=
> f PL/pgSQL function "audio_format_func" near line 15
> =20
> How will I handle exceptions in postgres?
Reading between t
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: compi
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_code