From: | Darren Ferguson <darren(at)crystalballinc(dot)com> |
---|---|
To: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: problem with my function |
Date: | 2002-05-24 19:55:44 |
Message-ID: | Pine.LNX.4.10.10205241554170.26850-100000@thread.crystalballinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-05-24 20:02:42 | Re: Case Insensitive Data Type |
Previous Message | Neil Conway | 2002-05-24 19:48:32 | Re: Question on crypt password |