Re: Compile error in function

Hi Stephan,

Thanks for your very fast answer - of course, the begin was the problem...

Koszonom!

Regards: Attila

----- Original Message -----
From: "Stephan Szabo" <sszabo(at)megazone(dot)bigpanda(dot)com>
To: "big_mafa" <big_mafa(at)freemail(dot)hu>
Cc: <pgsql-novice(at)postgresql(dot)org>
Sent: Saturday, August 16, 2003 9:49 PM
Subject: Re: [NOVICE] Compile error in function

>
> On Sat, 16 Aug 2003, big_mafa wrote:
>
> > There is a very annoying problem.
> > I created a very simple function, which can be created well, but if I
call
> > it, the following problem occurs:
>
> The function isn't checked until first run.
>
> > ERROR: parse error at or near "IF"
> > WARNING: plpgsql: ERROR during compile of cre_kitchen_log near line 1
> >
> > The Function is:
> >
> > CREATE OR REPLACE FUNCTION "public"."cre_kitchen_log" (date) RETURNS
integer
> > AS'
>
> You need a BEGIN here.