Re: problem with my function

It is a spelling mistake you are trying to return an interger instead of
an integer.

Also should the line with the IF statement not read

IF nCnt > 1500000 THEN
  RAISE EXCEPTION

??

HTH

Darren

Darren Ferguson

On Fri, 24 May 2002, Johnson, Shaunn wrote:

> Okay:
>
> I must be missing something vital; I thought my function
> was working properly the other day, but now I can't
> seem to figure out how I broke it.
>
> [snip code]
>
>
> drop function t_fastfunc(integer);
> create function t_fastfunc(integer)
> returns interger
> as '
> declare nCnt integer;
> begin
>         select count (*) into nCnt
>         from t_stage_member;
>         if nCnt < 1500000 then
>         RAISE EXCEPTION ''Number of records is more than 1.5M'';
>         return nCnt;
>         end if;
> end;
> ' language 'plpgsql';
>
> [/snip code]
>
> When I try to create it, I get the following error:
>
> [error]
>
> DROP
> psql:./function_cnt.sql:18: NOTICE:  ProcedureCreate: return type 'interger'
> is only a shell
> CREATE
>
>
> [/error]
>
> Question: What exactly is it tryiing to tell me about not returning a value?
> And could someone explain what it means by 'only a shell'?
>
> Thanks!
>
> -X
>